Re: Recursive queries? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Recursive queries?
Date
Msg-id 12649.1075907815@sss.pgh.pa.us
Whole thread Raw
In response to Re: Recursive queries?  (Hans-Jürgen Schönig <postgres@cybertec.at>)
Responses Re: Recursive queries?  (Hans-Jürgen Schönig <postgres@cybertec.at>)
List pgsql-hackers
Hans-Jürgen Schönig <postgres@cybertec.at> writes:
> Does this patch have a serious chance to make it into Pg some day?
> I think Oracle's syntax is not perfect but is easy to handle and many 
> people are used to it. In people's mind recursive queries = CONNECT BY 
> and many people (like me) miss it sadly.

I would prefer to see us supporting the SQL-standard syntax (WITH etc),
as it is (1) standard and (2) more flexible than CONNECT BY.  The Red
Hat work mentioned earlier in the thread was aimed at supporting the
standard syntax.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: Recursive queries?
Next
From: Tom Lane
Date:
Subject: Re: PITR Dead horse?