Re: [HACKERS] WITH RECUSIVE patches 0723

>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

> Martijn van Oosterhout <kleptog@svana.org> writes:
>> Since the problem is using the result of a WITH clause more than
>> once, would it be sufficient to simply detect that case and bail?
>> You don't want materialisation is most cases, there's just a few
>> where it is needed.

Tom> Really? I tried googling to see what other people thought that
Tom> the WITH clause was for, and the first relevant hit I got was
Tom> this one: http://www.oracle-developer.net/display.php?id=212
Tom> which certainly treats it as a key part of the feature.

Try searching for "common table expression".

--
Andrew (irc:RhodiumToad)

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers