Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id AAF83B5DC34
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Aug 2011 14:50:36 -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 52890-08 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Aug 2011 17:50:30 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from lo.gmane.org (lo.gmane.org [80.91.229.12])
	by mail.postgresql.org (Postfix) with ESMTP id 4FAF5B5DBFA
	for <pgsql-sql@postgresql.org>; Thu, 25 Aug 2011 14:50:29 -0300 (ADT)
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1Qwe4P-0000Bk-0G
	for pgsql-sql@postgresql.org; Thu, 25 Aug 2011 19:50:25 +0200
Received: from g224046019.adsl.alicedsl.de ([92.224.46.19])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Thu, 25 Aug 2011 19:50:24 +0200
Received: from tim by g224046019.adsl.alicedsl.de with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Thu, 25 Aug 2011 19:50:24 +0200
X-Injected-Via-Gmane: http://gmane.org/
Mail-Followup-To: pgsql-sql@postgresql.org
To: pgsql-sql@postgresql.org
From: Tim Landscheidt <tim@tim-landscheidt.de>
Subject: Re: Add one column to another
Date: Thu, 25 Aug 2011 17:50:14 +0000
Organization: <URI:http://www.tim-landscheidt.de/>
Lines: 23
Message-ID: <m3vctlqt2h.fsf@passepartout.tim-landscheidt.de>
References: <4E565A4E.9060400@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: g224046019.adsl.alicedsl.de
Mail-Copies-To: never
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)
Cancel-Lock: sha1:F2upfn9bai0hwcXoiUzpDeLGiYo=
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.432 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	RP_MATCHES_RCVD=-0.532
X-Spam-Level: 
X-Archive-Number: 201108/108
X-Sequence-Number: 35776

(anonymous) wrote:

> 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.

Try:

| SELECT first_name, surname, email1 AS email FROM testtable WHERE email1 IS NOT NULL UNION ALL
| SELECT first_name, surname, email2 AS email FROM testtable WHERE email2 IS NOT NULL;

Tim