>>>>> "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)