automatic sequence number?
От | apnv3@muha.net |
---|---|
Тема | automatic sequence number? |
Дата | |
Msg-id | 20031102142859.GA29500@muha.net обсуждение исходный текст |
Ответы |
Re: automatic sequence number?
Re: automatic sequence number? Re: automatic sequence number? |
Список | pgsql-jdbc |
Hello. I have a table with one field acting as primary key, the key is retrieved from a sequence-generator in postgresql. Currently I am executing two queries for every insert; Query #1 retrieves a number from a sequence-generator, and places it into the record. Query #2 performs the actual insert. Does anyone have an idea how to cut this down to only one query? And maybe somehow get back the primary key in the ResultSet. Or maybe this is how it is supposed to be done, it is just that I am not very experienced in jdbc/sql to know. :) Thanks in advance. //ap
В списке pgsql-jdbc по дате отправления: