Postgres Pro
Downloads
Home   >   mailing lists

Add one column to another - Mailing list pgsql-sql

From gvim
Subject Add one column to another
Date
Msg-id 4E565A4E.9060400@gmail.com
Whole thread Raw
Responses Re: Add one column to another  (Tony Capobianco <tcapobianco@prospectiv.com>)
Re: Add one column to another  ("David Johnston" <polobo@yahoo.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Florian Weimer
Date:
Subject: Re: new table with a select
Next
From: Tony Capobianco
Date:
Subject: Re: Add one column to another