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