PostgreSQL and select nextval
| From: | Alain Roger | Date: | Sun, 12 Aug 2007 07:35:34 +0000 |
| Subject: | PostgreSQL and select nextval | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-260725@lists.php.net to get a copy of this message | ||
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 nextval('tmp_importedxls_rec_id_seq'),' ^
I have the feeling that we can not use the select nextval(...) SQL request
in an INSERT INTO one under PHP.
Is it true?
thanks
--
Alain
------------------------------------
Windows XP SP2
PostgreSQL 8.2.3
Apache 2.2.4
PHP 5.2.3