Re: A Query question...

How big is your data set? I think your query: select * from clientes where min_c is in ["1234", "4567", "8901".....,"xxxx"] will run very slowly, even if min_c is indexed. Usually, when a seek in a list is involved you end up with a sequential read of the database. However, as you noted, you are running PostgreSQL, why don't you a) check the docs for PostgreSQL (You will find that the construction you want is legal.) and b) direct this to pgsql-general@postgresql.org for any question regarding speed of execution and alternatives. Regards - Miles Thompson Ermanno Iannacci wrote: > To the best I know, there is. > (there is in ms-access). > > > Hi... > > > > May be my question is so easy, but I can't find the solution....I'm using > a > > big query, I'm looking for several data in just one field, some like : > > > > select * from clientes where min_c="1234" or min_c="4567" or > > min_c="8901".....and so.... > > > > are there something like this ? : > > select * from clientes where min_c is in ["1234", "4567", > > "8901".....,"xxxx"] > > > > Any idea ??.... > > > > Thanks in advance..... > > > > PD: I'm using PostgreSQL... > > > > Ing. J@vier Morquecho Morquecho > > Cedetel > > Desarrollo de proyectos comerciales > > Tel : 177-10-87 > > Cel : 177-00-87 > > e-mail : jmorquec@cedetel.com.mx > > e-movil : 5281770087@emovil.cedetel.com.mx > > Home Cedetel : http://www.cedetel.com.mx > > > > "#define QUESTION ((bb) || !(bb)) // Shakespeare" > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net