Re: Query with boolean parameter - Mailing list psycopg

From Christophe Pettus
Subject Re: Query with boolean parameter
Date
Msg-id FDFFF1ED-3355-4A1B-9EAE-53724D0EBA55@thebuild.com
Whole thread Raw
In response to Re: Query with boolean parameter  (Paolo De Stefani <paolo@paolodestefani.it>)
Responses Re: Query with boolean parameter
List psycopg

> On Mar 19, 2022, at 05:10, Paolo De Stefani <paolo@paolodestefani.it> wrote:
> Switching to psycopg 3 i have to consider many more differences than i expected

There have been some changes in the way psycopg2 does parameter substitution, although that one is an interesting case!
You might consider using IS DISTINCT FROM as Daniele suggested, or just =, depending on how you want nulls handled. 


psycopg by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Re: Query with boolean parameter
Next
From: Adrian Klaver
Date:
Subject: Re: Query with boolean parameter