Re: Subselects open issue Nr. NEW
Zeugswetter Andreas IZ5 <andreas.zeugswetter@telecom.at>
From: Zeugswetter Andreas SARZ <Andreas.Zeugswetter@telecom.at>
To: "'pgsql-hackers@hub.org'" <pgsql-hackers@hub.org>
Date: 1998-02-17T08:52:50Z
Lists: pgsql-hackers
Gosh, please leave it in it is superb, great, fantastic ... If somebody defines a different behavior as standard in the future, we will need to tell him that he has a gordian knot in his brains :-) Andreas > I understand this. And this is how it works currently: > > select * from tab where (A,B) >= ANY (select X, Y from tab2); > > means: select tuples where A >= X _and_ B >= Y for some tuple from tab2. > ^^^^^ > 'AND' is used for all Op-s except for '<>' when 'OR' is used. > > Question is "should we drop this feature (?) or leave it as is ?"