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 C96D152894 for ; Wed, 1 Jun 2005 10:53:36 -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 58710-08 for ; Wed, 1 Jun 2005 13:53:33 +0000 (GMT) Received: from hotmail.com (bay104-f7.bay104.hotmail.com [65.54.175.17]) by svr1.postgresql.org (Postfix) with ESMTP id 8D3C452896 for ; Wed, 1 Jun 2005 10:53:32 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 1 Jun 2005 06:53:37 -0700 Message-ID: Received: from 65.54.175.204 by by104fd.bay104.hotmail.msn.com with HTTP; Wed, 01 Jun 2005 13:53:36 GMT X-Originating-IP: [65.54.175.204] X-Originating-Email: [dklugmann@hotmail.com] X-Sender: dklugmann@hotmail.com From: "David Klugmann" To: pgsql-sql@postgresql.org Subject: View unique rowid Date: Wed, 01 Jun 2005 13:53:36 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 01 Jun 2005 13:53:37.0127 (UTC) FILETIME=[4F0AA770:01C566B1] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.75 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER X-Spam-Level: * X-Archive-Number: 200506/4 X-Sequence-Number: 21605 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