Add one column to another

From: gvim <gvimrc(at)gmail(dot)com>
To: pgsql sql <pgsql-sql(at)postgresql(dot)org>
Subject: Add one column to another
Date: 2011-08-25 14:21:02
Message-ID: 4E565A4E.9060400@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have to deal with a table which contains:

first_name
surname
email1
email2

... and I would like to create a view which combines both email columns thus:

first_name
surname
email

It looks simple but I can't think of an obvious query.

gvim

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tony Capobianco 2011-08-25 14:30:21 Re: Add one column to another
Previous Message Florian Weimer 2011-08-25 10:44:16 Re: new table with a select