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 ?..
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 |