X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BE631D1E20F for ; Wed, 12 May 2004 14:19:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 09550-09 for ; Wed, 12 May 2004 14:18:47 -0300 (ADT) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id 1036CD1E25D for ; Wed, 12 May 2004 14:18:46 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id D27293CD3A; Wed, 12 May 2004 14:18:46 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id CF3813A10E for ; Wed, 12 May 2004 14:18:46 -0300 (ADT) X-Received: from localhost ([unix socket]) by ganymede.hub.org (Cyrus v2.2.3) with LMTP; Wed, 12 May 2004 14:17:15 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 293D73DC30 for ; Wed, 12 May 2004 14:16:01 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5) for scrappy@localhost (single-drop); Wed, 12 May 2004 14:16:01 -0300 (ADT) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.3) with LMTP; Wed, 12 May 2004 14:15:56 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0C8A5D1CA64 for ; Wed, 12 May 2004 14:15:56 -0300 (ADT) X-Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14450-03 for ; Wed, 12 May 2004 14:15:34 -0300 (ADT) X-Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id F2D16D1E23A for ; Wed, 12 May 2004 14:15:32 -0300 (ADT) X-Received: (qmail 4116 invoked by uid 500); 12 May 2004 17:20:19 -0000 Date: Wed, 12 May 2004 12:20:19 -0500 From: Bruno Wolff III To: pgsql-doc@postgresql.org Subject: IS DISTINCT FROM not documented Message-ID: <20040512172019.GA4069@wolff.to> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-DCC: : X-Spam-Pyzor: ReSent-Date: Wed, 12 May 2004 14:18:43 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-docs@postgresql.org ReSent-Subject: IS DISTINCT FROM not documented ReSent-Message-ID: <20040512141843.O35531@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/5 X-Sequence-Number: 2380 On one of the other lists a suggestion was made to use the IS DISTINCT FROM operator. I didn't remember seeing anything about this before so I tried to look it up in the 7.4.2 documentation. After not finding anything, I tried grepping the documentation source and was only able to find a reference to it in the release notes for 7.3. It may be that because of line breaks or mark up that I missed it. But even if it is there, it doesn't seem to be in an obvious place.