Re: SQL-question: returning the id of an insert querry

Scott Chapman <scott_list@mischko.com> writes:

> It would be nice if PostgreSQL could return the primary key it inserted 
> with but that may not be a fool-proof solution either.  Is there a nice 
> way to handle this situation?

Write a database function that inserts the record and returns the
primary key value?  That's probably the best way to insulate your app
from the database structure...

-Doug