"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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend