Re: When is a record NULL?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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>, Jeff Davis <pgsql(at)j-davis(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: When is a record NULL?
Date: 2009-07-24 18:05:55
Message-ID: 1664.1248458755@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
> I think the following should _not_ return true:
> select (null, null)::somerowtype is null;

Take it up with the SQL standards committee. The spec is 100% not
ambiguous about this.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-07-24 18:10:31 Re: When is a record NULL?
Previous Message Tom Lane 2009-07-24 17:59:45 Re: [PATCH v4] [libpq] Try to avoid manually masking SIGPIPEs on every send()