[SQL] newbie question * compare integer in a "where IN" statement

Title: Firma Correo Hi everybody, I'm trying to compare in a sentence like this (using PostGres 8.3) : select * from myTable where id_integer IN ('1,2,3,4') I want to get the records which key "id_integer" is 1 or 2 or 3 or 4. the type od my "id", of course

Re: [SQL] newbie question * compare integer in a "where IN" statement

) other forms are slow Regards Pavel Stehule 2011/7/13 Jose Ig Mendez <jmen...@andago.com> Hi everybody, I'm trying to compare in a sentence like this

[SQL] newbie question * compare integer in a "where IN" statement

Title: Firma Correo Hi everybody, I'm trying to compare in a sentence like this (using PostGres 8.3) : select * from myTable where id_integer IN ('1,2,3,4') I want to get the records which key "id_integer" is 1 or 2 or 3 or 4. the type od my "id",