Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAL0cAm50899 for ; Tue, 20 Nov 2001 19:38:10 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fAL0F6L55990 for pgsql-sql@postgresql.org; Tue, 20 Nov 2001 19:15:06 -0500 (EST) (envelope-from news) From: caldodge@fpcc.net (Calvin Dodge) X-Newsgroups: comp.databases.postgresql.sql Subject: Re: SELECT * FROM t where p or q; Date: 20 Nov 2001 16:15:03 -0800 Organization: http://groups.google.com/ Lines: 13 Message-ID: References: <3BF51764.8BEAC873@efbs-seafrigo.fr> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200111/298 X-Sequence-Number: 5680 frbn@efbs-seafrigo.fr wrote in message news:<3BF51764.8BEAC873@efbs-seafrigo.fr>... > SELECT * FROM tab WHERE num = x OR num = y; > > time: more than 10 mn !!! > > num is an integer. Parsers and optimizers don't always see what's _obvious_ to us. Have you tried: SELECT * from tab where num in (x,y);