agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedRequest for Formal Syntax of WHERE Clause Conditions
2+ messages / 2 participants
[nested] [flat]
* Request for Formal Syntax of WHERE Clause Conditions
@ 2025-01-21 16:01 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2025-01-21 16:01 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: mohamedhussein10445@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/sql-select.html
Description:
Dear PostgreSQL Team,
I am building a PostgreSQL parser and need a precise reference for the
formal syntax of condition used in the WHERE clause. While the documentation
covers many aspects in detail, I could not find a formal definition for what
constitutes a valid condition.
This information is critical for accurately parsing queries. Could you
please provide clarity or point me to relevant resources?
Thank you for your assistance!
Best regards,
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Request for Formal Syntax of WHERE Clause Conditions
@ 2025-01-21 17:26 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2025-01-21 17:26 UTC (permalink / raw)
To: mohamedhussein10445@gmail.com; +Cc: pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-01-21 17:26 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-01-21 16:01 Request for Formal Syntax of WHERE Clause Conditions PG Doc comments form <noreply@postgresql.org>
2025-01-21 17:26 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox