Postgres Pro
Downloads
Home   >   mailing lists

Re: syntax error with execute - Mailing list pgsql-general

From Vyacheslav Kalinin
Subject Re: syntax error with execute
Date
Msg-id 9b1af80e0805301404q4a0cd4e5n767fbc1b2d445985@mail.gmail.com
Whole thread Raw
In response to Re: syntax error with execute  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: syntax error with execute  ("A B" <gentosaker@gmail.com>)
List pgsql-general
Tree view

> EXECUTE 'INSERT INTO '||tablename||' ('||fields||') VALUES
> ('||vals||') RETURNING currval('''||seqname||''') INTO newid'

You probably were to do:

EXECUTE 'INSERT INTO '||tablename||' ('||fields||') VALUES
 ('||vals||') RETURNING currval('''||seqname||''')' INTO newid

Note where last quote goes.




pgsql-general by date:

Previous
From: Clodoaldo
Date:
Subject: Re: Query planning configuration and solid state drives
Next
From: "Fernando Moreno"
Date:
Subject: Re: syntax error with execute