Re: Oracle and Postgresql - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Oracle and Postgresql
Date
Msg-id g9guqe$vcf$1@ger.gmane.org
Whole thread Raw
In response to Re: Oracle and Postgresql  (David Fetter <david@fetter.org>)
Responses Re: Oracle and Postgresql
List pgsql-general
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



pgsql-general by date:

Previous
From: "mike stanton"
Date:
Subject: refcursor
Next
From: David Fetter
Date:
Subject: Re: Oracle and Postgresql