Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 14AC2B5DBD9 for ; Tue, 4 Oct 2011 22:04:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 59126-01 for ; Wed, 5 Oct 2011 01:04:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 4B436B5DBC4 for ; Tue, 4 Oct 2011 22:04:04 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id p95143V02802; Tue, 4 Oct 2011 21:04:03 -0400 (EDT) From: Bruce Momjian Message-Id: <201110050104.p95143V02802@momjian.us> Subject: Re: coalesce In-Reply-To: <1316623022-sup-9692@alvh.no-ip.org> To: Alvaro Herrera Date: Tue, 4 Oct 2011 21:04:03 -0400 (EDT) CC: Henry Drexler , Kevin Grittner , Pg Docs X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset="UNKNOWN-8BIT" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201110/1 X-Sequence-Number: 7001 Alvaro Herrera wrote: > > Excerpts from Henry Drexler's message of mié sep 21 12:50:18 -0300 2011: > > thanks, > > > > so I take it I am not getting those more complex examples (that are > > apparently beyond my use case), I will take a look at them again. > > Maybe the fix is just to add a simpler example, without altering the > wording (which seems pretty clear to me as well, but then I already know > what COALESCE does). The current example is: SELECT COALESCE(description, short_description, '(none)') ... What would a simpler one look like? -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +