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