Re: BUG #1099: bad syntax error localisation

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #1099: bad syntax error localisation
Date: 2004-03-11 15:01:22
Message-ID: 200403111601.22382.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-03-11 15:24:03 Re: BUG #1098: Multiple ON INSERT rules not applied properly in the case of INSERT...SELECT
Previous Message PostgreSQL Bugs List 2004-03-11 14:41:39 BUG #1099: bad syntax error localisation