Re:Hardly-used SQL Server functions that should be used more...
by cpburns2009 on Thursday April 06, 2017 @11:48AM
(#14051645)
I think PostgreSQL makes this the clearest because it supports arrays:
[ Parent
| on HN ]
Re:Hardly-used SQL Server functions that should be used more...
by MarkusWinand on Thursday April 06, 2017 @12:47PM
(#14052239)
Just FYI: starting with 9.4, PostgreSQL supports the FILTER clause. This would change this:
> array_remove(array_agg(producer.last_name), NULL) AS last_names
to that
> array_agg(producer.last_name) FILTER(WHERE producer.last_name IS NOT NULL) AS last_names
I wrote about FILTER here: http://modern-sql.com/feature/filter
And how to use ARRAYs rather than concatenated strings here: http://modern-sql.com/feature/listagg#alternative-array
Re:Hardly-used SQL Server functions that should be used more...
by cpburns2009 on Thursday April 06, 2017 @12:51PM
(#14052284)
I wasn't aware of that feature. Now I really need to push for upgrading PostgreSQL to a newer version.