hey.
that's just dandy-it works fine. thanks everyone for helping me sort out
my misunderstanings.
--
john
There is no operating system but linux and linus is its kernel maintainer.
Sometime in August Tom Lane assaulted keyboard and produced...
|harrold@sage.che.pitt.edu writes:
|> i want to insert data into a table that has a serialized key. then i want
|> the value of the key for the row i just inserted. from the stuff i read
|> on the net i though i was supposed to run the nextval command first then
|> preform the insert.
|
|That is about the simplest and most obvious way to do it, IMHO. What
|you're missing is that you have to explicitly insert the value you got
|from nextval() into the key column. If you allow the key column to be
|defaulted in the INSERT, then nextval() gets run again.
|
| regards, tom lane
|