Re: Add one column to another - Mailing list pgsql-sql

From vipul shah
Subject Re: Add one column to another
Date
Msg-id CALXQATYVAhfo+5UOix2tJ-tkn2pPfOd_Cr-1fo0E2CoxXZe_eA@mail.gmail.com
Whole thread Raw
In response to Re: Add one column to another  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-sql
Check this link.

It's useful to resolve the issue.

http://blog.ropardo.ro/2010/05/04/extending-postgresql-a-better-concat-operator/

- Vipul


On Thu, Aug 25, 2011 at 12:54 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Thu, Aug 25, 2011 at 8:52 AM, Oliveiros d'Azevedo Cristina
<oliveiros.cristina@marktest.pt> wrote:
> Something like this...?
>
> SELECT first_name,surname, email1 || ';' || email2
> FROM t_your_table;

If there's any nulls in email1 or email2 they'll need special handling
with coalesce.

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

pgsql-sql by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Add one column to another
Next
From: ppdcc@sapo.pt
Date:
Subject: st_offsetcurve