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

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

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 SELECT

[PHP] PostgreSQL and select nextval

2007-08-12 Thread Alain Roger
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

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