Subselects open issue Nr. NEW - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Subselects open issue Nr. NEW
Date
Msg-id 34E848A1.6FA1B00A@sable.krasnoyarsk.su
Whole thread Raw
List 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 by date:

Previous
From: Zeugswetter Andreas SARZ
Date:
Subject: AIX 4.1.5 is OK as of snapshot 16.2.98
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: AW: [HACKERS] Re: Subselects open issue Nr. 5