Subselects open issue Nr. NEW

Поиск
Список
Период
Сортировка
От Vadim B. Mikheev
Тема Subselects open issue Nr. NEW
Дата
Msg-id 34E848A1.6FA1B00A@sable.krasnoyarsk.su
обсуждение исходный текст
Список pgsql-hackers
Hm, new one. Oracle 6:

SQL> select * from a where (x,z) in (select y, l from b);

         X          Z
---------- ----------
         1          2

SQL> select * from a where (x,z) = ANY (select y, l from b);

         X          Z
---------- ----------
         1          2

SQL> select * from a where (x,z) >= ANY (select y, l from b);
select * from a where (x,z) >= ANY (select y, l from b)
                            *
ERROR at line 1:
ORA-00920: invalid relational operator

: only '=' and '<>' are allowed if there are more than one
expression on the left side of clause with subselect...

Is this in standard or Oracle' preference ?

Vadim
P.S. Maybe I should ask in DB newsgroups ?..

В списке pgsql-hackers по дате отправления: