Re: 9.17.5. Row-wise Comparison

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(at)acm(dot)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