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 <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
