Re: vacuum, performance, and MVCC - Mailing list pgsql-hackers

Jim Nasby <jnasby@pervasive.com> writes:
> What would be nice to add is the ability to perform that check more  
> easily. As of 8.1...
> ...
> if NEW=OLD then
> ...
> ERROR:  operator does not exist: test = test
> HINT:  No operator matches the given name and argument type(s). You  
> may need to add explicit type casts.

Hmm, there seems to be some asymmetry in the handling, because it works
for anonymous row constructors:

regression=# select row(a.*) = row(a.*) from int8_tbl a;
ERROR:  operator does not exist: int8_tbl = int8_tbl
LINE 1: select row(a.*) = row(a.*) from int8_tbl a;                       ^
HINT:  No operator matches the given name and argument type(s). You may need to
add explicit type casts.

regression=# select row(a.q1,a.q2) = row(a.q1,a.q2) from int8_tbl a;?column?
----------ttttt
(5 rows)


Someone oughta look into that...
        regards, tom lane