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
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 |