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

From Scott Marlowe
Subject Re: Add one column to another
Date
Msg-id CAOR=d=2e7Z7XHyfCv-f0bo2M9c61uB2pkTTP-hbJ4qVJ6gg6Kw@mail.gmail.com
Whole thread Raw
In response to Re: Add one column to another  ("Oliveiros d'Azevedo Cristina" <oliveiros.cristina@marktest.pt>)
Responses Re: Add one column to another  (vipul shah <vipmshah@gmail.com>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: Tim Landscheidt
Date:
Subject: Re: Add one column to another
Next
From: vipul shah
Date:
Subject: Re: Add one column to another