Niels Nes wrote:
On Tue, Nov 27, 2007 at 08:16:30PM +0100, Martin Kersten wrote:
Great. Is there a way to ask sequences for the previous value? Or is it only next?
only next.
So if I use SERIAL or AUTOINCREMENT columns, what is the way to get the most recently inserted ID? (Am assumming it's not possible?)
how about a max() over the column?
how about concurrent inserts ;-(
begin doit commit
Niels
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users