Sami, you said that PostgreSQL returns the oid of the inserted tuple.
Are you referring to the INSERT command, or the SELECT command
pointed out there?
For MySQL, you'd use SELECT LAST_INSERT_ID()
For Transact-SQL (used by SQL Server and Sybase), you'd use SELECT SCOPE_IDENTITY()
For PostgreSQL, you'd use SELECT CURRVAL('tablename_columnname_seq')
PostgreSQL at least returns the oid of the inserted tuple.
This of course is unique. This can be used to get any auto_increment etc stuff whit ease. So check the behaviour of the DB you use. It can provide some similar way to get that.
PS. How it seams that every time I encounter new DB system PostgreSQL seams to do things right or better. :) Or maybe I'm a litle bit biased to PostgreSQL. ;)
--------------------- To unsubscribe go to http://gameprogrammer.com/mailinglist.html
