| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Fetter <david(at)fetter(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: wCTE behaviour |
| Date: | 2010-11-14 22:14:34 |
| Message-ID: | 1289772874.21519.12.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On tor, 2010-11-11 at 19:35 +0200, Marko Tiikkaja wrote:
> I apologize, I had misunderstood what you are suggesting. But now
> that I do, it seems to be an even worse idea to go your way. Based on
> my research, I'm almost certain that the SQL standard says that the
> execution order is deterministic if there is at least one DML
> statement in the WITH list.
>
> Can anyone confirm this?
SQL:2008 doesn't allow any DML in the WITH list.
SQL:2011 has the "combined data store and retrieval" feature that was
discussed in another thread which basically implements the same thing.
They apparently avoid the whole issue by allowing only one data change
delta table per query.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-11-14 22:15:39 | Re: Re: Rethinking hint bits WAS: Protecting against unexpected zero-pages: proposal |
| Previous Message | Daniel Farina | 2010-11-14 22:14:25 | Re: Refactoring the Type System |