9.17.5. Row-wise Comparison - Mailing list pgsql-sql

From TJ O'Donnell
Subject 9.17.5. Row-wise Comparison
Date
Msg-id 4254AD87.2030508@acm.org
Whole thread Raw
Responses Re: 9.17.5. Row-wise Comparison  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
In tbl with columns a,b,c,d.
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

But I see in the manual at:
http://www.postgresql.org/docs/7.4/interactive/functions-comparisons.html#AEN12735
that only = and <> operators are supported.  Does this section of the manual
not properly apply to this query?  Is the manual in error, or am I
not understanding?

TJ


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Problems with Set Returning Functions (SRFs)
Next
From: Tom Lane
Date:
Subject: Re: 9.17.5. Row-wise Comparison