Re: BUG #17842: Adding a qual to a working query gets bogus syntax error

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>

To: Hans Buschmann <buschmann@nidsa.net>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Bug List <pgsql-bugs@lists.postgresql.org>

Date: 2023-03-14T18:19:32Z

Lists: pgsql-bugs

On Tue, Mar 14, 2023, 11:12 Hans Buschmann <buschmann@nidsa.net> wrote:

>
> 2. Why is it reporting an syntax error (supposed at parse time) and not a
> runtime error (supposed at execution time)
>
>
Your parsed query doesn't have a syntax error.  Data it processes does,
which is found when parsing that data during query execution.

David J.

>
>