The best way to insert rows into multiple tables? -
08-06-2004
, 04:04 PM
I can't seem to create a trigger and function
correctly to get it done....
I am trying to create the backend to a web-based
checklist that will insert the data into a db. Once
the chklst_header table is created, I want to create
the child tables with the same currval in the
sequence, preferably on insert into the header table.
Any ideas or examples are greatly appreciated!!!!!
Once I get this all figured out, I would be more than
happy to share the end result of my little project and
the source for others as well.
Thanks.
christian
cpemery [at] YahOO (dot) CoM
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html |