Re: Q: Does any ANSI-SQL standard address multi-column updates ?

From: Kendall <kendall_at_localhost.localdomain>
Date: Wed, 13 Feb 2002 15:58:02 -0800
Message-ID: <u6lvcanlt62564_at_news.supernews.com>


In article <c0d87ec0.0202131442.6bafff58_at_posting.google.com>, "--CELKO--" <71062.1056_at_compuserve.com> wrote:

> SQL-92 generalized the theta operators so they would work on row
> expressions and not just on scalars. This is not a popular feature yet,
> but it is very handy for situations where a key is made from more than
> one column, and so forth.

Glad to hear it's in the standard, but it's disappointing that it's not implemented in most RDBMS's. I tried the following in Oracle and got an error:

create table x( a integer, b integer);

select * from x where (a,b) < (1,2);

ORA-00920 Invalid relational operator

My db2 trial license expired, so I can't try it on that one ;-) . Received on Thu Feb 14 2002 - 00:58:02 CET

Original text of this message