Ummm... no. Cross posting is a BAD thing. Post to one list and if you don't get an answer there, then post to another list. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com ----- Original Message ----- From: "Josh Berkus" <josh@xxxxxxxxxxxx> To: "Zavier Sheran" <zsheran@xxxxxxxxx>; <pgsql-php@xxxxxxxxxxxxxx> Sent: Friday, October 12, 2001 12:49 PM Subject: Re: [PHP] Nextval > Zavier, > > In the future, cross-post this sort of request to pgsql-novice. More of > us DB Engine / Query Parser developers subscribe to that list than this > one. > > > Fetch a SERIAL field (ie. record_id) and get the > > highest value currently stored (ie. 1000), increment > > the value by 1 and store a record that will have the > > same value (1001) in record_id. So there must be a way > > with concurrency control. > > > > I went through the manuals and found the solution with > > NEXTVAL('serial'), but you have to create a sequence > > for that, and I don't know if it is the right way to > > do for what I want. > > Well, that depends on what you want to do, don't it? How about > describing what you're trying to accomplish rather than making us guess? > :-) > > -Josh
