2010/9/15 Marko Tiikkaja <marko.tiikk...@cs.helsinki.fi>: > On 2010-09-14 10:51 PM, Tom Lane wrote: >> My recollection is that whether a CTE is marked RECURSIVE or not affects >> its scope of visibility, so that confusing the two cases can result in >> flat-out incorrect parser behavior. > > The worst I can think of is: > > CREATE TABLE foo(a int); > > WITH t AS (SELECT * FROM foo) > INSERT INTO bar > WITH RECURSIVE foo (SELECT 1 AS a) > SELECT * FROM t; > > t will actually be populated with the results of the CTE, not the table foo.
Hmmm, that's true. But it seems unrelated to RECURSIVE option, right? Regards, -- Hitoshi Harada -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
