Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-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

pgsql-hackers by date

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

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group