> 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 resolve your problem... You can also try "create temp sequence" (review http://archives.postgresql.org/pgsql-sql/2005-05/msg00126.php) select 'saludos'; -- Rafa Couto (caligari) mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
