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 по дате отправления: