I was missing a few paranthesis like a nut.
Thanks for pointing out.
Thanks and regards
~Harpreet
On 9/1/06, Tom Lane <
[EMAIL PROTECTED]> wrote:
"Harpreet Dhaliwal" < [EMAIL PROTECTED]> writes:
> sprintf(buffer, "INSERT INTO headers (id, header_content) VALUES ( %d,
> SELECT contents FROM parser WHERE id = %d ), id, id);
> SPI_exec(buffer,0).
You're short some parentheses --- try executing a comparable query
manually.
regards, tom lane
