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" <tjo@acm.org> 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