Re: [PHP] PostgreSQL and select nextval

2007-08-16 Thread Martin Marques
Richard Lynch wrote: On Sun, August 12, 2007 2:35 am, Alain Roger wrote: I'm getting an error message when i run the following SQL request : $sql = "INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT nextval('tmp_importedxls_rec_id_seq'),'$pb')"; Error in SQL query: ERROR: syntax er

Re: [PHP] PostgreSQL and select nextval

2007-08-16 Thread Martin Marques
Alain Roger wrote: Hi, I'm getting an error message when i run the following SQL request : $sql = "INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT nextval('tmp_importedxls_rec_id_seq'),'$pb')"; Error in SQL query: ERROR: syntax error at or near "SELECT" LINE 2: VALUES (SELECT nex

Re: [PHP] PostgreSQL and select nextval

2007-08-13 Thread Richard Lynch
On Sun, August 12, 2007 2:35 am, Alain Roger wrote: > I'm getting an error message when i run the following SQL request : > $sql = "INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT > nextval('tmp_importedxls_rec_id_seq'),'$pb')"; > > Error in SQL query: ERROR: syntax error at or near

Re: [PHP] PostgreSQL and select nextval

2007-08-12 Thread brian
Alain Roger wrote: Hi, I'm getting an error message when i run the following SQL request : $sql = "INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT nextval('tmp_importedxls_rec_id_seq'),'$pb')"; Error in SQL query: ERROR: syntax error at or near "SELECT" LINE 2: VALUES (SELECT nex