Postgres Pro
Downloads
Home   >   mailing lists

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

From Teodor Sigaev
Subject Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued
Date
Msg-id 451D275E.1000100@sigaev.ru
Whole thread Raw
In response to pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to  (tgl@postgresql.org (Tom Lane))
Responses Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-committers
Tree view 
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@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-committers by date:

Previous
From: markir@pgfoundry.org (User Markir)
Date:
Subject: bizgres - bizgres: Fix big whereby cursors declared WITH HOLD would have
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to