DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:From:To:References:In-Reply-To:Subject:Date:Message-ID:MIME-Version:Content-Type:Content-Transfer-Encoding:X-Mailer:Thread-Index:Content-Language;
	b=RfcibbSplmLJMwIZFbmCZuG6PvMTqUZKLmunrl1+wHfcqqfhxUECFbIGqBscnZNnVtvKtEFP5yhzWiOCsBesQjDNRBIsCIXXWhTio8tknIXCkKaFfxSq6SGlm71BRrpyDLAdb9eh8GKIogy+Ybq6Q4IhbEUpQKV6F5JaQkIe03s=
	;
From: "David Johnston" <polobo@yahoo.com>
To: "'gvim'" <gvimrc@gmail.com>, "'pgsql sql'" <pgsql-sql@postgresql.org>
References: <4E565A4E.9060400@gmail.com>
In-Reply-To: <4E565A4E.9060400@gmail.com>
Subject: Re: Add one column to another
Date: Thu, 25 Aug 2011 10:53:33 -0400
Message-ID: <021201cc6336$c3547e20$49fd7a60$@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AQKPYgQR+3i+6hhpwQKKYBksNMzNppOnqRpQ
Content-Language: en-us

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.

-----------------------------------------------------------

SELECT first_name, surname, ARRAY[email1, email2] AS email
FROM [...]

David J.