pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Henry Drexler <alonup8tb@gmail.com>
Cc: Kevin Grittner <kevin.grittner@wicourts.gov>
Cc: Pg Docs <pgsql-docs@postgresql.org>
Subject: Re: coalesce
Date: Tue, 4 Oct 2011 22:39:42 -0400 (EDT)
Message-ID: <201110050239.p952dgu02102@momjian.us> (raw)
In-Reply-To: <7070.1317780542@sss.pgh.pa.us>

Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Here is a doc patch that at least explains the example.  Applied.
> 
> I think s/or/otherwise/ (both places) would make that read better.

Done with the attached patch.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

Attachments:


/rtmp/coalesce2 (text/x-diff, 817B) download
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
new file mode 100644
index 2f307c2..bedd8ba
*** a/doc/src/sgml/func.sgml
--- b/doc/src/sgml/func.sgml
*************** SELECT ... WHERE CASE WHEN x &lt;&gt; 0 
*** 10015,10022 ****
  <programlisting>
  SELECT COALESCE(description, short_description, '(none)') ...
  </programlisting>
!    This returns <varname>description</> if it is not null, or
!    <varname>short_description</> if it is not null, or <literal>(none)</>.
    </para>
  
     <para>
--- 10015,10022 ----
  <programlisting>
  SELECT COALESCE(description, short_description, '(none)') ...
  </programlisting>
!    This returns <varname>description</> if it is not null, otherwise
!    <varname>short_description</> if it is not null, otherwise <literal>(none)</>.
    </para>
  
     <para>

view thread (9+ messages)  latest in thread

Message-ID: <201110050239.p952dgu02102@momjian.us>
Permalink:  ../201110050239.p952dgu02102@momjian.us/
Also on:    postgresql.org/message-id/201110050239.p952dgu02102@momjian.us

 ·  · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: bruce@momjian.us, tgl@sss.pgh.pa.us, alvherre@commandprompt.com, alonup8tb@gmail.com, kevin.grittner@wicourts.gov
  Subject: Re: coalesce
  In-Reply-To: <201110050239.p952dgu02102@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox