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.marl...@gmail.com>wrote: > On Thu, Aug 25, 2011 at 8:52 AM, Oliveiros d'Azevedo Cristina > <oliveiros.crist...@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 >
