Re: WITH RECUSIVE patches 0723 - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: WITH RECUSIVE patches 0723
Date
Msg-id 873altr1ib.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: [PATCHES] WITH RECUSIVE patches 0723  (David Fetter <david@fetter.org>)
List pgsql-hackers
>>>>> "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)


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Review: DTrace probes (merged version) ver_03
Next
From: "David E. Wheeler"
Date:
Subject: Re: Do we really want to migrate plproxy and citext into PG core distribution?