Re: [INTERFACES] Re: Index unused with OR?

From: "Olaf Mittelstaedt" <mstaedt(at)va-sigi(dot)va(dot)fh-ulm(dot)de>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Re: Index unused with OR?
Date: 1998-05-14 16:53:52
Message-ID: 199805141554.RAA05331@gate.va.fh-ulm.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> 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(at)fh-ulm(dot)de
Fachhochschule Ulm Prittwitzstr. 10 89075 Ulm
Tel.: +49 (0)731-502-8220 Fax: -8270

Beati pauperes spiritu.

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Hirohama 1998-05-14 23:51:23 Re: retrieving varchar size
Previous Message Hannu Krosing 1998-05-14 15:10:02 Re: [INTERFACES] Re: Index unused with OR?