Hi, 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
