Re: When is a record NULL?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: 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 01:21:01
Message-ID: 407d949e0907231821y79028370h848aa23da2763dfe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jul 24, 2009 at 1:32 AM, David E. Wheeler<david(at)kineticode(dot)com> wrote:
> On Jul 23, 2009, at 4:22 PM, Tom Lane wrote:
>
>> Dunno how you can possibly come to that conclusion.  Those row
>> values are certainly distinct (according to both PG and the spec).
>
> Are they not both null?

Isn't that just what you were complaining about not being the case:

On Thu, Jul 23, 2009 at 11:29 PM, David E. Wheeler<david(at)kineticode(dot)com> wrote:
> try=# select ROW(1, NULL) IS NULL;
> ?column?
> ----------
> f
> (1 row)

--
greg
http://mit.edu/~gsstark/resume.pdf

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-07-24 01:30:21 Re: SE-PostgreSQL?
Previous Message Itagaki Takahiro 2009-07-24 01:17:42 Re: multi-threaded pgbench