From: "Roderick A(dot) Anderson" <raanders(at)altoplanos(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject:
Date: 1998-07-16 21:34:51
Message-ID: Pine.LNX.3.95.980716143350.2414A-100000@altoplanos.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)altoplanos(dot)net Altoplanos Information Systems, Inc.
Voice: 208.765.6149 212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814

Browse pgsql-sql by date

  From Date Subject
Next Message Wari Wahab 1998-07-17 06:59:47 Autoincrement
Previous Message Kurt Seel 1998-07-16 17:36:07 problems w/ tcl and large objects