Re: Start With... Connect By?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Start With... Connect By?
Date: 2009-07-13 14:51:29
Message-ID: h3fhli$kvp$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Fetter, 13.07.2009 16:32:
>> START WITH is Oracle specific whereas recursive CTEs are an ANSI
>> Standard (supported by PostgreSQL, Firebird and SQL Server).
>
> Not to mention DB2. I'm not sure how close Firebird is to actually
> shipping them...

Interesting, didn't know DB2 had them as well.

Firebird implemented recursive CTEs with Version 2.1 which was released April, 2008, more than a year ago. Which makes it the first OpenSource DBMS to implement them I guess.

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2009-07-13 14:53:35 Re: Question]
Previous Message Tim Landscheidt 2009-07-13 14:48:39 PostgreSQL 8.4 packages for Fedora 11?