Subselects open issue Nr. NEW

From: "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>
To: hackers(at)postgreSQL(dot)org
Subject: Subselects open issue Nr. NEW
Date: 1998-02-16 14:09:37
Message-ID: 34E848A1.6FA1B00A@sable.krasnoyarsk.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?..

Browse pgsql-hackers by date

  From Date Subject
Next Message Kent S. Gordon 1998-02-16 14:18:31 Re: DB logging (was: Problem with the numbers I reported yesterday)
Previous Message Vadim B. Mikheev 1998-02-16 13:53:17 Re: AW: [HACKERS] Re: Subselects open issue Nr. 5