Re: syntax error with execute
| От | Fernando Moreno |
|---|---|
| Тема | Re: syntax error with execute |
| Дата | |
| Msg-id | b1c45530805301422t3691050ai495c78ca610fb05b@mail.gmail.com обсуждение исходный текст |
| Ответ на | syntax error with execute ("A B" <gentosaker@gmail.com>) |
| Список | pgsql-general |
I haven't use the RETURNING clause before, but the "INTO" option, at least in SELECT sentences, must be outside of the string expression. This way: EXECUTE 'some query' INTO variable;
Cheers.
Cheers.
2008/5/30 A B <gentosaker@gmail.com>:
I have a query like this in a plpgsql function:
EXECUTE 'INSERT INTO '||tablename||' ('||fields||') VALUES
('||vals||') RETURNING currval('''||seqname||''') INTO newid'
and I get the response:
ERROR: syntax error at or near "INTO"
LINE 1: ...','2008','4',NULL) RETURNING currval('id_seq') INTO newid
And I do not understand this error. If I take the INSERT command and
run it by hand, it works fine, but it doesn't work in the function
when called by execute. Anybody has an idea on what is wrong and what
to do about it?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: