Re: 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'sjust a few>> where it is needed.
 
Tom> Really?  I tried googling to see what other people thought thatTom> the WITH clause was for, and the first
relevanthit I got wasTom> this one: http://www.oracle-developer.net/display.php?id=212Tom> which certainly treats it as
akey part of the feature.
 

Try searching for "common table expression".

-- 
Andrew (irc:RhodiumToad)