O David Klugmann έγραψε στις Jun 1, 2005 :
>
> 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.
Provided your ids are 4 bytes
From: Rafa Couto <[EMAIL PROTECTED]>
Reply-To: Rafa Couto <[EMAIL PROTECTED]>
To: David Klugmann <[EMAIL PROTECTED]>
CC: pgsql-sql@postgresql.org
Subject: Re: [SQL] View unique rowid
Date: Wed, 1 Jun 2005 16:53:19 +0200
> Is it possible to refer to a unique row identifier o
> 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.
You can get an oid from some table in view definition. May be it
results to resol
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