inserting data into multiple tables

From: Tony Grant <tony@animaproductions.com>
Date: 15 Oct 2001 15:58:13 +0200
To: postgres list <pgsql-general@postgresql.org>
Subject: [GENERAL] inserting data into multiple tables

Hello,

I have a table "refers_to"

individual_id int4
book_id int4

and another "individual"

individual_id int4 nextval('individual_serial')
name varchar
forename varchar

If the individual exists then get his id. If he doesn't allready exist
write his names to the table and get the newly created individual_id.

Then I though of using a function to write the book_id and the
individual_id to refers_to.

QUESTIONS

I am using JSP so the ideal seems to be stored functions in pl/pgsql?

What is the best order to do this in order to prevent a performance hit?

TIA

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly