Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 4DFE89FB1BF
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  3 Nov 2006 20:07:21 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 60903-07 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  3 Nov 2006 20:07:18 -0400 (AST)
X-Greylist: delayed 04:49:33.610478 by SQLgrey-
Received: from smtp-out.google.com (smtp-out.google.com [216.239.45.12])
	by postgresql.org (Postfix) with ESMTP id 35E779F9F77
	for <pgsql-sql@postgresql.org>; Fri,  3 Nov 2006 20:07:17 -0400 (AST)
Received: from zps36.corp.google.com (zps36.corp.google.com [172.25.146.36])
	by smtp-out.google.com with ESMTP id kA407CCh024892
	for <pgsql-sql@postgresql.org>; Fri, 3 Nov 2006 16:07:12 -0800
DomainKey-Signature: a=rsa-sha1; s=beta; d=google.com; c=nofws; q=dns;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=fras8/sulaeQc092PszFR2JW/pCE21F6FvnWMQH8kqOZoGNBQ+xAcwA2Y1H6oUFGz
	UQrdCTfIhrIH9s4Ta+Nhg==
Received: from ug-out-1314.google.com (ugck40.prod.google.com [10.66.112.40])
	by zps36.corp.google.com with ESMTP id kA40758h006433
	for <pgsql-sql@postgresql.org>; Fri, 3 Nov 2006 16:07:05 -0800
Received: by ug-out-1314.google.com with SMTP id k40so560995ugc
	for <pgsql-sql@postgresql.org>; Fri, 03 Nov 2006 16:07:05 -0800 (PST)
Received: by 10.78.203.13 with SMTP id a13mr3629105hug.1162598824791;
	Fri, 03 Nov 2006 16:07:04 -0800 (PST)
Received: by 10.78.140.8 with HTTP; Fri, 3 Nov 2006 16:07:04 -0800 (PST)
Message-ID: <3ddac38d0611031607w5564c44dk8e0c0a6cd5fdf0c@mail.gmail.com>
Date: Fri, 3 Nov 2006 16:07:04 -0800
From: "Dylan Lorimer" <edylan@google.com>
To: pgsql-sql@postgresql.org
Subject: Duplicate Fields + Views Questions
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_24655_12875042.1162598824771"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/47
X-Sequence-Number: 26699

------=_Part_24655_12875042.1162598824771
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

I've got 2 views - each with identical column names. I want to create an
aggregate view of both tables as a new view. But when I try to do this I
understandably get errors on duplicate fields.

As an example:

CREATE VIEW gnis_view AS SELECT * FROM gnis_international_view,
gnis_usa_view;
ERROR:  column "the_geom" duplicated
ERROR:  column "the_geom" duplicated

Any ideas on how I can achieve what I am seeking?
Cheers,
dylan

------=_Part_24655_12875042.1162598824771
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,<br><br>I've got 2 views - each with identical column names. I want to create an aggregate view of both tables as a new view. But when I try to do this I understandably get errors on duplicate fields.<br><br>As an example:
<br><br>CREATE VIEW gnis_view AS SELECT * FROM gnis_international_view, gnis_usa_view;<br>ERROR:&nbsp; column &quot;the_geom&quot; duplicated<br>ERROR:&nbsp; column &quot;the_geom&quot; duplicated<br><br>Any ideas on how I can achieve what I am seeking?
<br>Cheers,<br>dylan<br>

------=_Part_24655_12875042.1162598824771--