db
db copied to clipboard
Complicated Count SQL
SELECT count(DISTINCT "archive"."uid" )
FROM "argo_archived_workflows" AS "archive" JOIN "argo_archived_workflows_labels" AS "archive_labels" ON(archive.uid= archive_labels.uid)
WHERE("archive" . "namespace"= "ns")
How to express complicated count sql using db.v3 ?
I use Selector.Paginate(uint(limit)).TotalEntries(), but where's no way to custom count expression.
Thanks for your answer.
BTW, it's postgresql.