Re: Query with boolean parameter - Mailing list psycopg

> On Mar 18, 2022, at 16:56, Paolo De Stefani <paolo@paolodestefani.it> wrote:
> Is there any reason why the second query results in a syntax error?

There's not IS operator in PostgreSQL (or in SQL).  IS NULL, IS NOT NULL, IS TRUE, and IS FALSE are in effect unary
postfixoperators, so you can't construct them that way via parameter substitution.