Re: [Pypgsql-users] How to pass in arguments for 'in' operator

[Mike W. <mw...@mi...>]

At 09:52 PM 9/16/2002 -0400, Edmund Lian wrote:
>I'm stumped... could somebody please help me? I have a query that uses the
>in operator:
>
>matchDict = {'my_arg': [1, 2, 3]}
>sql = "select * from my_table where col_name in (%(my_arg)s)"
>c = cursor.execute(sql, matchDict)

Maybe I'm missing something... but should be as simple as:

>sql = "select * from my_table where col_name in (%s)"
>c = cursor.execute(sql, matchDict['my_arg'])