3 ms·
The only one I know of is that PostgreSQL has some nice ordinary aggregate functions which can be used well with window functions, like bool_and() and array_agg
by jeltz 11y ago
The only one I know of is that PostgreSQL has some nice ordinary aggregate functions which can be used well with window functions, like bool_and() and array_agg(). I can't think of an example on top of my head where it is useful but I know I have used them both.
- greggyb 11y agoThanks. There are definitely features in Postgres that I'm jealous of in the MS SQL Server world, and you've listed a couple of them.