Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [COMMITTERS] 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: [COMMITTERS] pgsql: Fix IS NULL and IS NOT NULL tests on row-valued
- Date: Fri, 29 Sep 2006 18:02:06 +0400
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:
- Prev by Date: Re: Backup and restore through JDBC
- Next by Date: Re: send()/receive() and on-disk storage
- Previous by thread: send()/receive() and on-disk storage
- Next by thread: Re: [COMMITTERS] pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to
- Indexes: