On Thu, 2005-04-07 at 06:44 -0700, TJ O'Donnell wrote: > it might break in future. > > > if (b > 1) then true > > else if (b = 1 and c > 2) then true > > else if (b = 1 and c = 2 and d > 3) then true > > else false > Your spec sql snippet is like an OR, isn't it, instead > of an AND as I'm reyling on?
not really. > After PG is to spec, will the behaviour I now see change? yes > > "TJ O'Donnell" <[EMAIL PROTECTED]> writes: > > > >>I've been using syntax like > >>select a from tbl where (b,c,d) > (1,2,3) > >> to mean > >>select a from t where b>1 and b>2 and d>3 if b=2, c=1 and d=1 then the expression (b,c,d) > (1,2,3) currently evaluates to false, but according to spec, should evaluate to true. gnari ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
