On Thursday 18 January 2007 00:57, Adam Rich wrote: > If it's a recent PG: > > select lastval() > > See this: > > http://www.postgresql.org/docs/8.2/interactive/functions-sequence.html >
probably more important that you see this: http://people.planetpostgresql.org/xzilla/index.php?/archives/169-Is-lastval-evil.html :-) -- Robert Treat Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
