View unique rowid
| От | David Klugmann | 
|---|---|
| Тема | View unique rowid | 
| Дата | |
| Msg-id | BAY104-F738FF8AD0C05D867CF6D5B2050@phx.gbl обсуждение исходный текст | 
| Ответы | Re: View unique rowid Re: View unique rowid | 
| Список | pgsql-sql | 
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
В списке pgsql-sql по дате отправления: