Re: INSERT question

Insert the row into the parent table (the one with the primary key), then do
a
select max(<serial-column>) from parent_table;
This will give you the greatest number in the table, that is if everything
went ok the number from the row you just inserted. Then insert the row(s)
into the second table and use the value you got from the parent table in the
foreign key

cheers

Wilco

"Brian" <Brian(at)McSweeney(dot)iol(dot)ie> schreef in bericht
news:1f5f2b44(dot)0111130130(dot)17e8e57a(at)posting(dot)google(dot)com(dot)(dot)(dot)
| Hi everyone,
| I've a little question about using insert statements. I've got a
| parent table with a "serial" (automatically incrementing integer)
| primary key. I have a child table with a foreign key which references
| that primary key. My question is:
|
| To insert values into the child table corresponding to an entry in the
| parent table, how do I get a reference to the serial primary key (so
| as I can reference it for the foreign key entry)
|
| Hope you understand what I mean. This should be a regular occurance
| and seeing as I'm not an sql guru, I just don't have a clue!
|
| Any help would be SOOO appreciated.
| Brian