Pretty sure you have to create the query as a string and execute that.
On Fri, May 30, 2008 at 9:55 AM, A B <gentosaker(at)gmail(dot)com> wrote:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-general by date
|Next:||From: Vyacheslav Kalinin||Date: 2008-05-30 21:04:52|
|Subject: Re: syntax error with execute|
|Previous:||From: Marc Weber||Date: 2008-05-30 19:46:25|
|Subject: Re: Howto implement sxntax and semantic complie time chock for|