Prepared Statement for IN function

[pravinasp]

Could anyone please tell me if it is possible to use prepared statement in postgresql for IN function? if its possible then hows it done? What I want to have would look something like this,

prepare my_query as
select something from sometable
where some_column IN ($1);
execute my_query('lookup_value','lookup_value','lookup_val ue')

Please let me know how this could be achieved in Postgresql,

Tons of Thanks

[pravinasp]

Does someone have an answer for it? Please let me know as am designing my classes and it depends on this now.

Thanks a lot

[rski]

Could anyone please tell me if it is possible to use prepared statement in postgresql for IN function? if its possible then hows it done? What I want to have would look something like this,

prepare my_query as
select something from sometable
where some_column IN ($1);
execute my_query('lookup_value','lookup_value','lookup_val ue')

Please let me know how this could be achieved in Postgresql,

Tons of Thanks

I'm not sure if I get you problem because the query you wrote works fine but you must write that statement will receive a parameter

prepare my_query(int) as
select something from sometable
where some_column IN ($1);

Did't it work with your postgres?

[pravinasp]

Sorry my bad, query works fine.