| From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Oracle and Postgresql |
| Date: | 2008-09-01 14:39:09 |
| Message-ID: | g9guqe$vcf$1@ger.gmane.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-www |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2008-09-01 14:59:08 | Re: Oracle and Postgresql |
| Previous Message | mike stanton | 2008-09-01 14:31:24 | refcursor |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2008-09-01 14:59:08 | Re: Oracle and Postgresql |
| Previous Message | David Fetter | 2008-09-01 14:08:56 | Re: Oracle and Postgresql |