agora inbox for pgsql-docs@postgresql.org  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: mohamedhussein10445@gmail.com
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Request for Formal Syntax of WHERE Clause Conditions
Date: Tue, 21 Jan 2025 12:26:03 -0500
Message-ID: <3358480.1737480363@sss.pgh.pa.us> (raw)
In-Reply-To: <173747531931.1071.13547694511760149052@wrigleys.postgresql.org>
References: <173747531931.1071.13547694511760149052@wrigleys.postgresql.org>

PG Doc comments form <noreply@postgresql.org> writes:
> I am building a PostgreSQL parser and need a precise reference for the
> formal syntax of condition used in the WHERE clause.

We do not have one.  You might be able to extract what you need from
our Bison grammar though:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/parser/gram.y;h=d7f9c00c409...

starting more or less from the a_expr production.

Keep in mind that this is a moving target, as we frequently add
new syntax features.

			regards, tom lane





view thread (2+ messages)

Message-ID: <3358480.1737480363@sss.pgh.pa.us>
Permalink:  ../3358480.1737480363@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3358480.1737480363@sss.pgh.pa.us

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, mohamedhussein10445@gmail.com, pgsql-docs@lists.postgresql.org
  Subject: Re: Request for Formal Syntax of WHERE Clause Conditions
  In-Reply-To: <3358480.1737480363@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox