Re: [HACKERS] [COMMITTERS] pgsql: Fix IS NULL and IS NOT NULL tests on row-valued

2006-09-29 Thread Teodor Sigaev 

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: [EMAIL PROTECTED]
   WWW: http://www.sigaev.ru/

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq

Re: [HACKERS] [COMMITTERS] pgsql: Fix IS NULL and IS NOT NULL tests on row-valued expressions to

2006-09-29 Thread Tom Lane 
Teodor Sigaev [EMAIL PROTECTED] writes:
 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.

Wups, I missed that part of the docs, will fix.  Thanks.

regards, tom lane

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings