News for hackers. Stuff that matters.
Re:PostgreSQL Magic by jeltz on Friday September 11, 2015 @11:13AM (#10204104)
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.
Re:PostgreSQL Magic by greggyb on Friday September 11, 2015 @11:21AM (#10204157)
Thanks. 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.