But in Postgres, you can have as many "autoincrement" columns in a table as you want - how will you handle that?
And what's wrong with select currval()? Chris > I am wondering if I can get some input on the logic that I would need to > code a function that would mimic mysql's last_insert_id().. > > Here is what last_insert_id() does in mysql: > Returns the last automatically generated value that was inserted into an > AUTO_INCREMENT column. > mysql> SELECT LAST_INSERT_ID(); > -> 195 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])