Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 81F57B5DBF7
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Aug 2011 11:21:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 71264-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Aug 2011 14:21:06 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id 059C0B5D803
	for <pgsql-sql@postgresql.org>; Thu, 25 Aug 2011 11:21:05 -0300 (ADT)
Received: by wyg24 with SMTP id 24so1701344wyg.19
	for <pgsql-sql@postgresql.org>; Thu, 25 Aug 2011 07:21:05 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type:content-transfer-encoding;
	bh=RnVjMWrhf7rE2Z0Gc20bv3vaHQObpZ8Wk9FKWfoEA2Q=;
	b=xLyPagf/x+8K17jSZrBwXHdNHZ0Hs0Ed6FWMhvKynwWJqOyE9h6aEpxd2/Kg4dz8Cd
	9j1iLjDn3la7l0anWq12FFNuQqhkyDSwATG3G4MWMW73U6r1NWX8VupqUdFJdeC3y9kL
	/4oCU5Eui178tZ8TgoPKCib++QhQMOR8C81wU=
Received: by 10.216.157.8 with SMTP id n8mr717217wek.48.1314282065411;
	Thu, 25 Aug 2011 07:21:05 -0700 (PDT)
Received: from [10.0.0.5] (heaton.plus.com [212.159.45.120])
	by mx.google.com with ESMTPS id 8sm495302wbx.34.2011.08.25.07.21.03
	(version=SSLv3 cipher=OTHER); Thu, 25 Aug 2011 07:21:04 -0700 (PDT)
Message-ID: <4E565A4E.9060400@gmail.com>
Date: Thu, 25 Aug 2011 15:21:02 +0100
From: gvim <gvimrc@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US;
	rv:1.8.1.23) Gecko/20090812 Lightning/0.9 Thunderbird/2.0.0.23
	Mnenhy/0.7.5.0
MIME-Version: 1.0
To: pgsql sql <pgsql-sql@postgresql.org>
Subject: Add one column to another
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.499 tagged_above=-5 required=5 tests=BAYES_05=-0.5,
	FREEMAIL_FROM=0.001
X-Spam-Level: 
X-Archive-Number: 201108/104
X-Sequence-Number: 35772

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