On 07-03-2009 21:41:21 +0000, Stefan de Konink wrote: > This code adds the last_id variable to MonetDB5/SQL to implement 'in SQL' > access to the last updated sequence, in a similar fashion as the @@IDENTITY > found in MSSQL. For future compatibility a procedure like get_last_row_id() > found in other databases, this function would have to return the variable > found. The variable is updated when m->last_id is updated. > > The code was added to have last_id support within the ODBC interface; > required for phpBB compatibility.
Weird, ODBC already knows it, and more reliable, via the response of Q_UPDATE. I think it was already implemented in ODBC even? It's available in mapilib, using mapi_get_last_id. ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
