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