On 6 May 2002 at 12:43, Joel Burton wrote: > > -----Original Message----- > > From: Dan Langille [mailto:[EMAIL PROTECTED]] > > Sent: Monday, May 06, 2002 12:41 PM > > To: Joel Burton > > Cc: [EMAIL PROTECTED] > > Subject: Re: [ADMIN] SERIAL Field > > > > > In any event, inserting then using currval() is the standard practice > > > around here, and it works great. Nothing fishy at all here, > > nothing to see, > > > move on. > > > > Why is that "less risk"? > > It's not; nextval() is just fine. I was half asleep and thinking, I think, > of another database when I wrote that. > > "You say nextval() + write, I say write + currval()..."
So long as a given application does not mix the two approaches, everything should be fine. -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly