X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 66E0E5287E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  1 Jun 2005 09:00:11 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 54462-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  1 Jun 2005 12:00:09 +0000 (GMT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.190])
	by svr1.postgresql.org (Postfix) with ESMTP id A56D652876
	for <pgsql-sql@postgresql.org>; Wed,  1 Jun 2005 09:00:05 -0300 (ADT)
Received: from [212.227.126.200] (helo=mrvnet.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 1DdRtC-0005p1-00
	for pgsql-sql@postgresql.org; Wed, 01 Jun 2005 14:00:02 +0200
Received: from [172.23.4.147] (helo=config20.kundenserver.de)
	by mrvnet.kundenserver.de with esmtp (Exim 3.35 #1)
	id 1DdRtB-0000D8-00
	for pgsql-sql@postgresql.org; Wed, 01 Jun 2005 14:00:01 +0200
Received: from www-data by config20.kundenserver.de with local (Exim 3.35 #1
	(Debian)) id 1DdRtB-0001kV-00
	for <pgsql-sql@postgresql.org>; Wed, 01 Jun 2005 14:00:01 +0200
To: <pgsql-sql@postgresql.org>
Subject: =?iso-8859-1?Q?Unique_keys_on_views?=
From: <dklugmann@kerenor.co.uk>
Message-Id: <28054826$1117626704429da150e73fc2.98783130@config20.schlund.de>
X-Binford: 6100 (more power)
X-Originating-From: 28054826
X-Mailer: Webmail
X-Routing: UK
X-Received: from config20 by 82.44.127.42 with HTTP id 28054826 for
	pgsql-sql@postgresql.org; Wed,  1 Jun 2005 13:58:01 +0200
Content-Type: text/plain;
	charset="iso-8859-1"
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit
X-Priority: 3
Date: Wed,  1 Jun 2005 13:58:01 +0200
X-Provags-ID: kundenserver.de abuse@kundenserver.de ident:@172.23.4.147
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=NO_REAL_NAME
X-Spam-Level: 
X-Archive-Number: 200506/70
X-Sequence-Number: 21671


Hi 

Is it possible to refer to a unique row identifier on a view ?

I have the following view but in a subsequent select I need to refer to
each row's unique identifier and I know oid's are not valid for a view.

create view persontransit
as
select personid, planet, name as aspectname, position as planetposition,
position+angle as transitposition
from personplanet, aspect
union
select personid, planet, name as aspectname, position as planetposition,
position-angle as transitposition 
from personplanet, aspect
where name != 'OPPOSITION';

Many thanks

David