On Fri, 2010-02-12 at 16:59 -0500, Tom Lane wrote: > Came across something interesting while looking at Marko Tiikkaja's > cut-down WITH patch. I see that our grammar allows a WITH clause in > front of VALUES, and analyze.c makes some effort to process it, but > AFAICT there isn't any actual use case for this because you can't > reference the WITH clause from the body of VALUES:
create table tmp(a int); insert into tmp values(2); with tmp2 as (select a + 1 as b from tmp) values((select b from tmp2)); column1 --------- 3 (1 row) Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers