Re: [HACKERS] Re: Subselects open issue Nr. NEW
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Andreas.Zeugswetter@telecom.at (Zeugswetter Andreas SARZ)
Cc: pgsql-hackers@hub.org
Date: 1998-02-17T16:02:49Z
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 ?" > > > I think my recent posting answers this. You have to comare from left-to-right until you find an answer. -- Bruce Momjian maillist@candle.pha.pa.us