Re: SQL2011 and writeable CTE - Mailing list pgsql-hackers

From Hitoshi Harada
Subject Re: SQL2011 and writeable CTE
Date
Msg-id AANLkTi=hB1TOoEU9K+ECONqsup00BtsiXwn5sXa7Jmk2@mail.gmail.com
Whole thread Raw
In response to Re: SQL2011 and writeable CTE  (Hitoshi Harada <umi.tanuki@gmail.com>)
Responses Re: SQL2011 and writeable CTE
List pgsql-hackers
2010/11/9 Hitoshi Harada <umi.tanuki@gmail.com>:
> 2010/11/8 Pavel Stehule <pavel.stehule@gmail.com>:
>> 2010/11/8 Hitoshi Harada <umi.tanuki@gmail.com>:
>
>>> 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 something like materialized table.
>>>
>>> So I think we are going on writeable "CTEs" unless there are no
>>> objection rather than pursuing the standard.
>>> Thanks for sharing anyway.
>>>
>>
>> I found, so writeable CTE was implemented in Microsoft SQL server too.
>> Can be our implementation compatible?
>>
>
> I don't believe MS SQL Server doesn't implement such our writeable

I mean, "I don't believe it implements..." :)

-- 
Hitoshi Harada


pgsql-hackers by date:

Previous
From: Hitoshi Harada
Date:
Subject: Re: SQL2011 and writeable CTE
Next
From: Andrew Dunstan
Date:
Subject: Re: Should we use make -k on the buildfarm?