honeysql 2023-09-04 | Slack Archive

markaddleman18:09:34

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

seancorfield18:09:26

:ignore-nulls isn't built-in -- can you provide a bit more context here?

markaddleman18:09:48

I completely forgot that I registered my own :ignore-nulls function. That’s kind of embarrassing 🙂

markaddleman18:09:29

I’m not sure how common it is across dialects but it’s regularly used in BigQuery SQL

seancorfield18:09:56

Feel free to create a GH issue for it to be added with a link to supporting docs.

👍 2

markaddleman16:09:32

Finally got to it: https://github.com/seancorfield/honeysql/issues/504

markaddleman16:09:39

Happy to add more docs if helpful

seancorfield17:09:03

Thanks. I'll add :ignore-nulls and :respect-nulls as "special syntax".

🙏 2

2023-09-04

Channels