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

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 Wed Feb 13 2002 - 17:58:02 CST