El 24/11/20 a las 17:52, Daniele Varrazzo escribió:
Hello,

I wrote a description of the psycopg3 adaptation system and the main
differences compared to psycopg2: available at
https://www.psycopg.org/articles/2020/11/24/psycopg3-adaptation/

Initial API docs are available at
https://www.psycopg.org/psycopg3/docs/adaptation.html

Feedback is welcome. Cheers!

-- Daniele


Hi Daniele, thanks for your effort.

After reading the docs i have a question about the parameters in the 'in' clause.

In psycopg2 i do:

 params = (1,2,3,4)
 cursor.execute("select * from mytable where field1 in %s", (params,))

or

 params = ('black','red','green')
 cursor.execute("select * from mytable where field2 in %s", (params,))

What will it be like in psycopg3, will it be the same?, will I have to create a special adapter?

Thanks
--
Oswaldo Hernández


Reply via email to