I noticed something odd when trying to use the row-wise comparison
mentioned in the release notes for 8.2 and in the docs
http://developer.postgresql.org/pgdocs/postgres/functions-comparisons.html#ROW-WISE-COMPARISON
This sets up a suitable test:
create type myrowtype AS (a integer, b integer);
On 10/20/06, Jeremy Drake [EMAIL PROTECTED] wrote:
I noticed something odd when trying to use the row-wise comparison
mentioned in the release notes for 8.2 and in the docs
http://developer.postgresql.org/pgdocs/postgres/functions-comparisons.html#ROW-WISE-COMPARISON
This sets up a suitable
Jeremy Drake [EMAIL PROTECTED] writes:
select rowval from myrowtypetable ORDER BY ROW((rowval).*) USING ;
ERROR: operator does not exist: record record
This isn't required by the spec, and it's not implemented. I don't
see that it'd give any new functionality anyway, since you can always
do
On Fri, 20 Oct 2006, Tom Lane wrote:
Jeremy Drake [EMAIL PROTECTED] writes:
select rowval from myrowtypetable ORDER BY ROW((rowval).*) USING ;
ERROR: operator does not exist: record record
This isn't required by the spec, and it's not implemented. I don't
see that it'd give any new
Jeremy Drake [EMAIL PROTECTED] writes:
I just think it is quite unexpected that the operator is defined in some
places and not in others.
Row-wise comparison isn't an operator, it's a syntactic construct.
Consider
(now(), 'foo', 42) (SELECT timestampcol, textcol, intcol FROM sometable WHERE