Re: BUG #1099: bad syntax error localisation - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #1099: bad syntax error localisation
Date
Msg-id 200403111601.22382.peter_e@gmx.net
Whole thread Raw
In response to BUG #1099: bad syntax error localisation  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Responses Re: BUG #1099: bad syntax error localisation
List pgsql-bugs
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
>
> You may notice that word "not" is not at character 1,
> where there is "CREATE".

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

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1099: bad syntax error localisation
Next
From: Tom Lane
Date:
Subject: Re: BUG #1098: Multiple ON INSERT rules not applied properly in the case of INSERT...SELECT