Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Tom Lane <tgl(at)postgresql(dot)org>
Cc: pgsql-committers(at)postgresql(dot)org, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued
Date: 2006-09-29 14:02:06
Message-ID: 451D275E.1000100@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

9.17.5. Row-wise Comparison
"These constructs test a row value for null or not null. A row value is
considered not null if it has at least one field that is not null."

I suppose, it should be changed too.

Tom Lane wrote:
> the SQL spec, viz IS NULL is true if all the row's fields are null, IS NOT
> NULL is true if all the row's fields are not null. The former coding got
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-09-29 14:31:02 Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to
Previous Message User Markir 2006-09-29 06:21:14 bizgres - bizgres: Fix big whereby cursors declared WITH HOLD would have

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Schaber 2006-09-29 14:03:50 Re: send()/receive() and on-disk storage
Previous Message Tom Dunstan 2006-09-29 14:00:43 Re: Backup and restore through JDBC