Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #511

Re: UPDATE as subquery of SELECT

Show all headers | View raw

On 4/4/2011 6:59 PM, Serge Rielau wrote:
> On 3/28/2011 9:50 AM, Jerry Stuckle wrote:
>> On 3/28/2011 7:58 AM, Serge Rielau wrote:
>>>> Interesting, Serge. I haven't seen that in the SQL specs. Do you know
>>>> which version specified it?
>>> Should be in SQL:2008
>>> Checking....
>>>
>>> We first published the extension at VLDB 2004:
>>> http://portal.acm.org/citation.cfm?id=1316774
>>>
>>> Cheers
>>> Serge
>>>
>>
>> Interesting, and I can see where there could be performance
>> improvements. But which version of the ANSI standard picked it up?
>>
> I have bugged our standards reps and here is the feedback I got:
>
> "Yes, SELECT FROM INSERT has indeed made it into ANSI as well as ISO SQL
> standards, but it is not yet visible to the wider world since it was
> introduced after the current version of SQL standard, SQL-2008, came
> out. It will become visible when the next version gets published, which
> is expected either late this year or early next year. It normally takes
> 3 to 4 year cycle for a new version of SQL standard to come out."
>
> If you are interested I can send you a PDF of the submission.
>
> Cheers
> Serge
>

No, that's fine, Serge.  And that makes sense - I didn't think it was in 
the current standard.

I appreciate the info!

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Back to comp.databases.mysql | Previous | Next — Previous in thread | Find similar

Thread

Re: UPDATE as subquery of SELECT Serge Rielau <srielau@ca.ibm.com> - 2011-04-04 18:59 -0400
  Re: UPDATE as subquery of SELECT Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-04 19:59 -0400

csiph-web