...

Поиск
Список
Период
Сортировка
От Roderick A. Anderson
Тема ...
Дата
Msg-id Pine.LNX.3.95.980716143350.2414A-100000@altoplanos.net
обсуждение исходный текст
Список 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@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


В списке pgsql-sql по дате отправления:

Предыдущее
От: Kurt Seel
Дата:
Сообщение: problems w/ tcl and large objects
Следующее
От: Konstantinos Vassiliadis
Дата:
Сообщение: Modelling relationships