Re: Add one column to another

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "Oliveiros d'Azevedo Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>
Cc: gvim <gvimrc(at)gmail(dot)com>, pgsql sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Add one column to another
Date: 2011-08-25 17:54:05
Message-ID: CAOR=d=2e7Z7XHyfCv-f0bo2M9c61uB2pkTTP-hbJ4qVJ6gg6Kw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message vipul shah 2011-08-25 19:46:11 Re: Add one column to another
Previous Message Tim Landscheidt 2011-08-25 17:50:14 Re: Add one column to another