3 ms·
> I'd never heard of Window Functions Go ahead and give it a shot. Once you get used to it, you cannot live without it. Another killer feature in my opinion i
by davyjones 14y ago
> I'd never heard of Window Functions
Go ahead and give it a shot. Once you get used to it, you cannot live without it.
Another killer feature in my opinion is the recursive query: http://www.postgresql.org/docs/current/static/queries-with.html http://www.postgresql.org/docs/current/static/queries-with.h...
- jaggederest 14y agoAnd, to go along with the recursive queries, the GEQO - genetic query optimizer, for when your queries are NP-complete to even optimize.
- jiggy2011 14y agoI wish I had know of these sooner, with MySQL I was jumping through all kinds of hoops to organize hierarchical data in my DB without generating insane amounts of queries.