On Tue, Oct 23, 2001 at 02:38:04PM -0400, Kevin HaleBoyes wrote: > Is this actually guaranteed to work? > What happens if another call to append_test() is made such that > the insert takes place in the first call, then the insert takes place > in the second call before the select currval().
Yes, it's guarenteed to work. If you examine the documentation for currval(), you will get the last value returned by nextval() *in this session*. Whatever happens in other sessions is irrelevent. I think this needs to be highlighted more in the documentation since many people miss this very important point. -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Magnetism, electricity and motion are like a three-for-two special offer: > if you have two of them, the third one comes free. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
