Received: from mailex.rz.fh-ulm.de (Mailex.rz.fh-ulm.de [141.59.42.15]) by hub.org (8.8.8/8.7.5) with ESMTP id LAA02115 for ; Thu, 14 May 1998 11:55:53 -0400 (EDT) Received: from gate.va.fh-ulm.de (gate.va.fh-ulm.de [141.59.15.1]) by mailex.rz.fh-ulm.de (8.8.8/8.8.8) with SMTP id RAA09539 for ; Thu, 14 May 1998 17:55:29 +0200 Received: by gate.va.fh-ulm.de (8.6.11) id RAA05331; Thu, 14 May 1998 17:54:30 +0200 Message-Id: <199805141554.RAA05331@gate.va.fh-ulm.de> Received: from va-sigi.va.fh-ulm.de(141.59.12.12) by gate.va.fh-ulm.de via smap (V1.3) id sma005329; Thu May 14 17:54:26 1998 Received: from VA-SIGI/SpoolDir by va-sigi.va.fh-ulm.de (Mercury 1.21); 14 May 98 17:54:09 +0200 Received: from SpoolDir by VA-SIGI (Mercury 1.21); 14 May 98 17:54:01 +0200 From: "Olaf Mittelstaedt" Organization: Verwaltung FH Ulm To: pgsql-interfaces@postgreSQL.org Date: Thu, 14 May 1998 17:53:52 +0100 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: [INTERFACES] Re: Index unused with OR? Priority: normal In-reply-to: <355B094A.43F1DAAE@trust.ee> > This is probably the wrong list, but ... Sorry for using the wrong list, I discovered the problem using ODBC. There are now too many PostgreSQL lists to subscribe to all... :( > select * from p where (m=29000) union select * from p where (m=30000); Thanks for your hint, the query above works much better. Regards, Olaf -- Olaf Mittelstaedt - IuK - mittelstaedt@fh-ulm.de Fachhochschule Ulm Prittwitzstr. 10 89075 Ulm Tel.: +49 (0)731-502-8220 Fax: -8270 Beati pauperes spiritu.