Re: last value

Since this is a data integrity question (I presume) as much as an 
application question, you could put a trigger on the 1st table that says, 
"when a new record is added, seed data in other tables".  I have it at 
work.  If you need more info, let me know.

Thom Dyson
Director of Information Services
Sybex, Inc.
 


pgsql-php-owner@xxxxxxxxxxxxxx wrote on 05/04/2005 09:18:12 AM:

> I tried to search some thread that could help me, but didn't find
> anything (maybe because I didn't know how to search).

> I have a script that insert some values in a table. After this, I have
> to take the value of the primary key just inserted, and insert it in
> another table, all in the same script.

> How can I do that? Or if you have a better idea of how to get the last
> value and insert in the other table, please tell me.

> Thanks.
> --
> Roni Warken

> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq