Re: Common Table Expressions (WITH RECURSIVE) patch

On Mon, Sep 15, 2008 at 06:46:16PM +0900, Tatsuo Ishii wrote:
> > > * Single Evaluation:
> > > 
> > >   with
> > >     foo(i) as (select random() as i)
> > >   select * from foo union all select * from foo;
> > >            i
> > >   -------------------
> > >    0.233165248762816
> > >     0.62126633618027
> > >   (2 rows)
> > > 
> > >   The standard specifies that non-recursive WITH should be
> > >   evaluated once.
> > 
> > What shall we do? I don't think there's an easy way to fix this as
> > Tom suggested. Maybe we should not allow WITH clause without
> > RECURISVE for 8.4?
> 
> This is a still remaing issue...

I don't think that the spec explicitly forbids this.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate