Hi,
I'm still trying to understand how the sequences work under PostgreSQL.
for example i have a sequence called : users_user_id_seq
with :
current value = 1
min value = 1
max value = 9223372036854775807
start = 1
a typical "serial" field.
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.
how can i get the current value (to use it into my "insert into statement") and by the same time,. increment it by 1, to be ready for the next time ?
--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008
