Re: Add one column to another

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(dot)marlowe(at)gmail(dot)com>wrote:

> On Thu, Aug 25, 2011 at 8:52 AM, Oliveiros d'Azevedo Cristina
> <oliveiros(dot)cristina(at)marktest(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>