9.17.5. Row-wise Comparison

From: TJ O'Donnell <tjo(at)acm(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: 9.17.5. Row-wise Comparison
Date: 2005-04-07 03:48:23
Message-ID: 4254AD87.2030508@acm.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2005-04-07 04:47:42 Re: 9.17.5. Row-wise Comparison
Previous Message Otto Blomqvist 2005-04-06 22:31:45 Re: [GENERAL] Problems with Set Returning Functions (SRFs)