| 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: | Whole Thread | Raw Message | 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 |