John McCawley wrote:
In PostgreSQL 8 and up:SELECT lastval();
Actually it's better to use currval.See http://people.planetpostgresql.org/xzilla/index.php?/archives/169-Is-lastval-evil.html
-- Postgresql & php tutorials http://www.designmagick.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/