Re: sequence

"Alain Roger" <raf(dot)news(at)gmail(dot)com> writes:
> to perform an autoincrement in my SQL queries...specially while i use insert
> into i do the following thing :

> INSERT INTO mytable VALUES
> (
> select nextval('users_user_id_seq'),
> ...
> );

> however this get the currentvalue + 1, or during creating the sequence i
> must say that start = 0.

Really? Works fine for me:

regression=# create sequence foo start with 10;
CREATE SEQUENCE
regression=# select nextval('foo');
nextval
---------
10
(1 row)

regression=# select nextval('foo');
nextval
---------
11
(1 row)

If you're initializing the sequence some other way, such as with
setval(), maybe you need to make use of the is_called option to setval().

regards, tom lane