dbTalk Databases Forums  

Re: [BUGS] CONNECT BY

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [BUGS] CONNECT BY in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] CONNECT BY - 05-06-2004 , 11:46 PM






Ruslan A Dautkhanov <rusland (AT) scn (DOT) ru> writes:
Quote:
Here's the patch ( http://gppl.terminal.ru/ ), which allow
PostgreSQL use queries like
connect by id = prior parent_id
Isn't this the same patch that we rejected a year or two back?

Quote:
as described in SQL standard...
AFAIK there is no such syntax in any version of the SQL standard.
The syntax that *is* there in SQL99 uses "WITH" to achieve roughly
the same results, but with much syntactic difference from Oracle.

If you'd like to submit a patch that implements spec-compatible
WITH, I can pass along some preliminary work that Andrew Overholt
did at Red Hat.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.