Value of serial data type after insert. - Mailing list pgsql-general

I was wondering if there was a way to get the value of serial data
type after an insert.  For example, you have the following table:

create table my_names   (
       id    serial unique,
       name    varchar(10)
);

And then you do the following:

insert into my_names values ('Ernie');

How do I get the value of the "id" column after the insert command?  I
want to make sure that I avoid race conditions, for example:

User A: insert into my_names values ('Ernie');
User B: insert into my_names values ('Bob');
User A: select last_value from my_names_id_seq;
User B: select last_value from my_names_id_seq;

Both user A and B end up with the same returned value after the select
command.

Note this would be coded through PHP if this helps at all.  Thanks.

-Ernie