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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

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