I can't find it in the documentation and was having no luck with WAGs.
Is there a functionality like Oracle's ROWNUM in PostgreSQL? I need to
populate a primary key in an existing table and this has always been the
easiest method for me.
update my_table
set tbl_key = ROWNUM;
If there isn't how about a method to convert an OID into float8
format? Heck I'm open to other methods also.
TIA,
Rod
--
Roderick A. Anderson
raanders@altoplanos.net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814
