X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7EC265E40BB for ; Sat, 7 Aug 2004 11:09:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23203-07 for ; Sat, 7 Aug 2004 14:08:51 +0000 (GMT) Received: from builder.localdomain (unknown [61.94.126.177]) by svr1.postgresql.org (Postfix) with SMTP id 3E8DE5E4077 for ; Sat, 7 Aug 2004 11:08:39 -0300 (ADT) Received: (qmail 20540 invoked from network); 7 Aug 2004 14:08:40 -0000 Received: from localhost (HELO localhost.localdomain) (127.0.0.1) by builder.localdomain with SMTP; 7 Aug 2004 14:08:40 -0000 Received: from 192.168.0.103 by builder.localdomain (MWN SMTPD 0.1.4-pre/20040709) id f5c5a58ef0c3517d7dd61ba3654116e2 with SMTP; 07 Aug 2004 14:08:40 +0000 Message-ID: <4114E264.2090709@zara.6.isreserved.com> Date: Sat, 07 Aug 2004 21:08:36 +0700 From: David Garamond User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7b) Gecko/20040421 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: Documenting NULLVALUE() and NONNULLVALUE() Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/15 X-Sequence-Number: 2475 Perl and PHP programmers (such as myself) are accustomed to using defined()/isset() and so when wanting to test null value they might look to the Functions chapter (9) instead of the SQL Syntax chapter (4). It took me some time before I found out about ISNULL, IS NULL, NOTNULL, IS NOT NULL. In MySQL I am accustomed to using ISNULL() function. Perhaps we can change section 9.1 from "Logical Operators" to "Logical Functions and Operators"? NULLVALUE() and NONNULLVALUE() can be documented there, along with IS, IS NULL, and IS NOT NULL (which also don't seem to have been covered yet in Chapter 9). Should I submit a patch? -- dave