Re: [HACKERS] SQL2011 and writeable CTE

2010-11-08 Thread Peter Eisentraut
On mån, 2010-11-08 at 10:34 +0900, Hitoshi Harada wrote: > Hmm, this looks very different from our writeable CTEs. And I can see > many issues like syntax ambiguity and execution order if we support > it. AFAIK the most significant reason why we are working on CTEs is > that CTEs are regarded as so

Re: [HACKERS] SQL2011 and writeable CTE

2010-11-08 Thread Pavel Stehule
2010/11/8 Hitoshi Harada : > 2010/11/9 Hitoshi Harada : >> 2010/11/8 Pavel Stehule : >>> 2010/11/8 Hitoshi Harada : >> Hmm, this looks very different from our writeable CTEs. And I can see many issues like syntax ambiguity and execution order if we support it. AFAIK the most signific

Re: [HACKERS] SQL2011 and writeable CTE

2010-11-08 Thread Hitoshi Harada
2010/11/9 Hitoshi Harada : > 2010/11/8 Pavel Stehule : >> 2010/11/8 Hitoshi Harada : > >>> Hmm, this looks very different from our writeable CTEs. And I can see >>> many issues like syntax ambiguity and execution order if we support >>> it. AFAIK the most significant reason why we are working on CT

Re: [HACKERS] SQL2011 and writeable CTE

2010-11-08 Thread Hitoshi Harada
2010/11/8 Pavel Stehule : > 2010/11/8 Hitoshi Harada : >> Hmm, this looks very different from our writeable CTEs. And I can see >> many issues like syntax ambiguity and execution order if we support >> it. AFAIK the most significant reason why we are working on CTEs is >> that CTEs are regarded as

Re: [HACKERS] SQL2011 and writeable CTE

2010-11-07 Thread Pavel Stehule
2010/11/8 Hitoshi Harada : > 2010/11/8 Peter Eisentraut : >> On sön, 2010-11-07 at 21:28 +0900, Hitoshi Harada wrote: >>> I've read this Peter's post: >>> >>> http://petereisentraut.blogspot.com/2010/04/news-from-sql-standard.html >>> >>> which says in SQL2011 has a new feature: >>> >>> > Combined

Re: [HACKERS] SQL2011 and writeable CTE

2010-11-07 Thread Hitoshi Harada
2010/11/8 Peter Eisentraut : > On sön, 2010-11-07 at 21:28 +0900, Hitoshi Harada wrote: >> I've read this Peter's post: >> >> http://petereisentraut.blogspot.com/2010/04/news-from-sql-standard.html >> >> which says in SQL2011 has a new feature: >> >> > Combined data change and retrieval. PostgreSQL

Re: [HACKERS] SQL2011 and writeable CTE

2010-11-07 Thread Peter Eisentraut
On sön, 2010-11-07 at 21:28 +0900, Hitoshi Harada wrote: > I've read this Peter's post: > > http://petereisentraut.blogspot.com/2010/04/news-from-sql-standard.html > > which says in SQL2011 has a new feature: > > > Combined data change and retrieval. PostgreSQL does something like this > > with

[HACKERS] SQL2011 and writeable CTE

2010-11-07 Thread Hitoshi Harada
I've read this Peter's post: http://petereisentraut.blogspot.com/2010/04/news-from-sql-standard.html which says in SQL2011 has a new feature: > Combined data change and retrieval. PostgreSQL does something like this with > RETURNING, but this feature is more elaborate and allows the writing of