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 416D25E40BA for ; Sat, 7 Aug 2004 16:57:23 -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 12438-10 for ; Sat, 7 Aug 2004 19:57:18 +0000 (GMT) Received: from builder.localdomain (unknown [61.94.124.34]) by svr1.postgresql.org (Postfix) with SMTP id E5A7A5E40AC for ; Sat, 7 Aug 2004 16:57:14 -0300 (ADT) Received: (qmail 31657 invoked from network); 7 Aug 2004 19:57:11 -0000 Received: from localhost (HELO localhost.localdomain) (127.0.0.1) by builder.localdomain with SMTP; 7 Aug 2004 19:57:11 -0000 Received: from 192.168.0.103 by builder.localdomain (MWN SMTPD 0.1.4-pre/20040709) id e7823562665403f5dc1880b8fc3192fe with SMTP; 07 Aug 2004 19:57:11 +0000 Message-ID: <41153413.2050608@zara.6.isreserved.com> Date: Sun, 08 Aug 2004 02:57:07 +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: Tom Lane Cc: pgsql-docs@postgresql.org Subject: Re: Documenting NULLVALUE() and NONNULLVALUE() References: <4114E264.2090709@zara.6.isreserved.com> <549.1091898070@sss.pgh.pa.us> In-Reply-To: <549.1091898070@sss.pgh.pa.us> 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/17 X-Sequence-Number: 2477 Tom Lane wrote: >>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). > > I don't think we should document nullvalue() and nonnullvalue(), because > they are not standard. > > As for "not covered", IS NULL is documented in 9.2 Comparison Operators. Ah, it's not immediately visible so I missed that. Thanks. -- dave