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