On Thu, 5 Oct 2000, Jeff Davis wrote:
> Here is essentially what I am trying to do:
>
> I want to have a 'serial' type column, so that it provides a unique
> identifier for records. However, when I do the insert, I need the know
> what value was assigned to that so I can use it in another table for
> reference, by doing another insert.
When you have used your SERIAL, the currval() function holds the last
value inserted. It's the only way to guarantee getting the correct value,
especially when there's multiple sessions going on.
Peter
--
Peter T Mount peter@retep.org.uk http://www.retep.org.uk
PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/
Java PDF Generator http://www.retep.org.uk/pdf/