I would like to auto increment my sequence when i'm going to insert a new record into my table.
for that i wanted to use :
insert into immense.statususer (statususer_id, statususer_type) values (SELECT nextval( 'statususer_statususer_id_seq' ),'customer');
however, i get an error message in pgAdmin III, as following : ERROR: syntax error at or near "SELECT" at character 168
i do not under because if I run SELECT nextval( 'statususer_statususer_id_seq' ) alone, it works perfectly and increment the sequence. moreover, everything regarding the table is correct. so where is the problem ?
thanks a lot,
-- Alain ------------------------------------ Windows XP SP2 PostgreSQL 8.1.4 Apache 2.0.58 PHP 5