| From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | row wise comparison broken |
| Date: | 2004-09-09 14:09:01 |
| Message-ID: | 20040909.230901.70226609.t-ishii@sra.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Following result seems strange since it is not what the standard
expects:
test=# select (1,1) > (0,10);
?column?
----------
f
(1 row)
On the other hand I see following in the doc:
-----------------------------------------
9.17.5. Row-wise Comparison
(expression [, expression ...]) operator (expression [, expression ...])
Each side is a list of scalar expressions; the two lists must be of
the same length. Each side is evaluated and they are compared
row-wise. Presently, only = and <> operators are allowed in row-wise
comparisons.
-----------------------------------------
I guess this means that PostgreSQL does not fully support SQL's
row-wise comparison. We need to add this to the TODO list?
--
Tatsuo Ishii
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-09-09 15:33:40 | Re: psql questions: SQL, progname, copyright dates |
| Previous Message | Greg Sabino Mullane | 2004-09-09 11:37:13 | Re: psql questions: SQL, progname, copyright dates |