News for hackers. Stuff that matters.
Re:PostgreSQL Magic by greggyb on Friday September 11, 2015 @10:31AM (#10203848)
I don't disagree in the general case, but I'm particularly interested in window functions here, as they are part of the SQL standard and seem equivalent between MS SQL Server and Postgres (I don't have near enough experience in other RDBMS's to speak to their implementations), despite being called out with some regularity as a Postgres-specific nicety.
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.