David Fetter, 01.09.2008 16:08:
because we are making extensive usage of Oracle's windowing
functions
http://umitanuki.net/pgsql/wfv04/design.html
I knew there was work going on regarding this, but I didn't know how definite the decision was to integrate that into 8.4
It's too bad lead(), lag() won't make it
It's even more fun with CTEs.
<http://wiki.postgresql.org/wiki/CTEReadme>
Recursive CTE are quite cool, and a valid "replacement" for CONNECT BY.
I've used it already with SQL Server 2005 and once you get the idea it's really nice.
Those will both be fixed, at least to a large degree, in 8.4 :)
What exactly means "large degree" :)
Regards
Thomas
