Fork me on GitHub
#honeysql
<
2022-04-04
>
seancorfield20:04:16

@jabhi207 I don't even know what SQL that is... can you link to docs for it? Is it DB-specific? If it is a binary operator, you can register it yourself and use it:

dev=> (sql/register-op! :is-distinct-from)
nil
dev=> (sql/format {:where [:is-distinct-from :a :b]})
["WHERE a IS DISTINCT FROM b"]
If it is ANSI SQL, I can add it to the core.

jabhi20703:04:22

Yes it is binary operator. The solution works. Didn’t knew about sql/register-op! . Thanks

dharrigan20:04:19

Could be this:

dharrigan20:04:18

Looks like it's part of the standard too

dharrigan20:04:18

also in mysql