From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | Zavier Sheran <zsheran(at)yahoo(dot)com>, pgsql-php(at)postgresql(dot)org |
Subject: | Re: Nextval |
Date: | 2001-10-12 16:49:44 |
Message-ID: | web-146731@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Zavier Sheran | 2001-10-13 04:51:40 | Nextval again |
Previous Message | Marco Colombo | 2001-10-12 11:56:18 | Re: Nextval |