On Jul 24, 2009, at 11:37 AM, Jeff Davis wrote:
Hmmm ... that suggests that we may not be handling IS DISTINCT FROM
correctly for rowtypes. I haven't read that part of the spec, but
I would've guessed that the spec wants it to be consistent with
IS NULL.
Our behavior appears to match the standard, which covers this case in
8.15.General Rules.1.c.iv.
Good, because what I'm doing is comparing rows returned by two
different cursors using IS DISTINCT FROM, and what I need the
comparison to do is to ensure that two rows are not equivalent
(distinct) unless all of their values are the same, column to column,
including NULLs.
Best,
David
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
