Postgres Pro
Downloads
Home   >   mailing lists

Re: Anything like Oracle's "connect by" SQL? - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Anything like Oracle's "connect by" SQL?
Date
Msg-id 200310012247.08606.josh@agliodbs.com
Whole thread Raw
In response to Re: Anything like Oracle's "connect by" SQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
Tom,

> There's not a whole lot of interest around here in emulating Oracle's
> proprietary CONNECT BY syntax.  Some work has been done towards
> implementing the SQL99 standard's features for "recursive queries"
> (WITH et al), but it's unfinished work as of 7.4.

But we have CONNECT_BY as a function, thanks to Joe Conway.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Anything like Oracle's "connect by" SQL?
Next
From: Cath Lawrence
Date:
Subject: Python gotcha with boolean variables