| 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/
| 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 |
| 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 |