Received: from trends.net (clio.trends.ca [209.47.148.2]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA01865 for ; Mon, 27 Sep 1999 23:00:38 -0400 (EDT) (envelope-from lockhart@alumni.caltech.edu) Received: from localhost (root@hectic-1.jpl.nasa.gov [128.149.68.203]) by trends.net (8.8.8/8.8.8) with ESMTP id WAA09246 for ; Mon, 27 Sep 1999 22:46:48 -0400 (EDT) Received: from alumni.caltech.edu (lockhart@localhost [127.0.0.1]) by localhost (8.8.7/8.8.7) with ESMTP id CAA00176; Tue, 28 Sep 1999 02:42:28 GMT Sender: lockhart@trends.net Message-ID: <37F02B14.7423BCAF@alumni.caltech.edu> Date: Tue, 28 Sep 1999 02:42:28 +0000 From: Thomas Lockhart X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tom Lane , Constantin Teodorescu CC: Albert REINER , PostgreSQL-SQL Subject: Re: [SQL] IFNULL - problem References: <21872.938390693@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit > The docs are in error: it's spelled NULLIF. In fact they also get > the definition wrong. The SQL92 spec says... > Both func.sgml and sqlfunc.hlp give incorrect definitions as well as > giving the wrong spelling. I've got the sgml docs fixed locally, and will commit sometime soon (the next few days). The other place to fix is in the pgaccess docs, which I suppose are maintained elsewhere. Constantin? - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California