Re: BUG #1099: bad syntax error localisation

Peter Eisentraut <peter_e@gmx.net> writes:
> PostgreSQL Bugs List wrote:
>> CREATE FUNCTION test1 (int) RETURNS int LANGUAGE sql
>> AS 'not even SQL';
>> ERROR:  syntax error at or near "not" at character 1

> The error message refers to the function body, which is parsed
> separately and therefore starts the count at 1.

I'm surprised there is no CONTEXT line here though.  You would have
gotten one for a syntax error in plpgsql; I must have overlooked doing
it for SQL.

            regards, tom lane