Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Fri, 29 Sep 2006 18:02:06 +0400
- Message-id: <451D275E.1000100@sigaev.ru> <text/plain>
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/
- Follow-Ups:
- References:
- Prev by Date: bizgres - bizgres: Fix big whereby cursors declared WITH HOLD would have
- Next by Date: Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to
- Previous by thread: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to
- Next by thread: Re: pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to
- Indexes: