Fork me on GitHub
#honeysql
<
2022-02-11
>
markbastian17:02:33

How might I express SELECT COUNT(*) > 0 in honeysql? I’ve got

:select [:%count.*]
so far for the count. Just trying to get that > 0 in there. Thanks!

markbastian18:02:38

yeah, like that, but when I use that I get:

Execution error (AssertionError) at honeysql.format/seq->sql (format.cljc:385).
Assert failed: Alias should have two parts[[:> [:count :*] 0]]
(= 2 (count x))

john-shaffer18:02:06

Oh, sorry, that's version 2. I don't know how to do it in v1

👍 1