Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WlnIl-0005oM-Lk for pgsql-admin@arkaria.postgresql.org; Sat, 17 May 2014 22:41:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WlnIl-0004wj-44 for pgsql-admin@arkaria.postgresql.org; Sat, 17 May 2014 22:41:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WlnIj-0004v9-Hi for pgsql-admin@postgresql.org; Sat, 17 May 2014 22:41:57 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WlnIg-0002ZQ-Bj for pgsql-admin@postgresql.org; Sat, 17 May 2014 22:41:57 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1WlnIe-0007Zt-De for pgsql-admin@postgresql.org; Sat, 17 May 2014 15:41:52 -0700 Date: Sat, 17 May 2014 15:41:52 -0700 (PDT) From: David G Johnston To: pgsql-admin@postgresql.org Message-ID: <1400366512382-5804370.post@n5.nabble.com> In-Reply-To: References: <5377C0BE.3050102@enterprisedb.com> Subject: Re: CONCAT function equivalent MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Fabian Santiago wrote > It created one line in the column with everything strung together. And why would you expect anything different? If you want embedded newlines you need to add them yourself during the concatenation. See my post on the -novice list where you also posted this same original question. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/CONCAT-function-equivalent-tp5804325p5804370.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin