Clojurians Log v2
Clojure programming
Channels
Apps
honeysql
markaddleman 2023-09-04T18:25:34.475299Z
Is there a special incantation to to produce ARRAY_AGG(col IGNORE NULLS) ? I’ve successfully used [:ignore-nulls :col] in analytic functions but it doesn’t seem to work for :array_agg
seancorfield 2023-09-04T18:36:26.497609Z
:ignore-nulls isn't built-in -- can you provide a bit more context here?
markaddleman 2023-09-04T18:37:48.352869Z
I completely forgot that I registered my own :ignore-nulls function. That’s kind of embarrassing 🙂
markaddleman 2023-09-04T18:38:29.592539Z
I’m not sure how common it is across dialects but it’s regularly used in BigQuery SQL
seancorfield 2023-09-04T18:41:56.511829Z
Feel free to create a GH issue for it to be added with a link to supporting docs.
👍 1
markaddleman 2023-09-08T16:06:32.248889Z
Finally got to it: https://github.com/seancorfield/honeysql/issues/504
markaddleman 2023-09-08T16:06:39.623739Z
Happy to add more docs if helpful
seancorfield 2023-09-08T17:12:03.598909Z
Thanks. I'll add :ignore-nulls and :respect-nulls as "special syntax".
🙏 1