From: | David E(dot) Wheeler <david(at)kineticode(dot)com> |
---|---|
To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Brendan Jurd <direvus(at)gmail(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: When is a record NULL? |
Date: | 2009-07-24 22:05:27 |
Message-ID: | 0AC123E8-CAC3-4227-860C-31DA38A5D286@kineticode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2009-07-24 22:15:20 | Re: When is a record NULL? |
Previous Message | Andrew Dunstan | 2009-07-24 22:03:16 | Re: Enable SSPI on cygwin |