RE: unique id's and incr
От | Dave Cramer |
---|---|
Тема | RE: unique id's and incr |
Дата | |
Msg-id | 00bb01c113dd$7c456f70$8201a8c0@inspiron обсуждение исходный текст |
Ответ на | unique id's and incr ("G.L. Grobe" <gary@grobe.net>) |
Список | pgsql-general |
Gary,
The most generic way to do this is to create a sequence, and then select next('sequencename') and use that to insert into the row
Dave
-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of G.L. Grobe
Sent: July 23, 2001 8:00 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] unique id's and incr
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of G.L. Grobe
Sent: July 23, 2001 8:00 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] unique id's and incr
During the creation of my database, I'm doing a:CREATE UNIQUE INDEX account_idx ON Accounts (account_id);to add new rows to my table and keep the id's unique.During runtime (accessing by JDBC), is there anyway when adding a new row to a table to know the last id entry so as to incr the next one for a new id. I was thinking there might be a way to do this w/o having to query the table for the last id and incr the id before I do another insert.Any help much appreciated.
В списке pgsql-general по дате отправления: