| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | "David E(dot) Wheeler" <david(at)kineticode(dot)com>, Brendan Jurd <direvus(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: When is a record NULL? |
| Date: | 2009-07-24 18:20:44 |
| Message-ID: | 1248459644.25874.69.camel@monkey-cat.sm.truviso.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 2009-07-24 at 13:35 -0400, Merlin Moncure wrote:
> I think the following should _not_ return true:
> select (null, null)::somerowtype is null;
>
> The reasoning being that
It's not at all clear to me that you can "reason" effectively about SQL
logic semantics. Upon which laws are you reasoning? Certainly not 2VL
boolean logic.
The standard is what it is. If it says that some NULLs are red and some
NULLs are blue, then we'd probably support it.
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2009-07-24 18:37:13 | Re: When is a record NULL? |
| Previous Message | David E. Wheeler | 2009-07-24 18:19:39 | Re: When is a record NULL? |