Last Insert

Hello All,

I have two tables, the first is parental and the second is a child of the
first.

Ex.:

create table first (id SERIAL, descrip CHAR(20));
create table second (id INTEGER references first(id), state CHAR(2));

I have `all' the values to make the inserts in the two tables (ie, descrip
and state), so I `would' use:

INSERT into first (descrip) values ($descr);
INSERT into second (id,state) values (?????????,$state);

As you can see, I don't know the ID number assigned to first.id, so I
can't do the INSERT in the `second' table...

How can I discover the number gave to the SERIAL field in the first table?

Thanks in advance,

Marcelo