Robert Treat wrote:
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
:-)
lastval's main benefit is in aiding the port of MySQL apps (being a
drop-in replacement for LAST_INSERT_ID()). without lastval such ports
can be really difficult.
So it does have its place. :)
