Re: [INTERFACES] Re: Index unused with OR? - Mailing list pgsql-interfaces

From Olaf Mittelstaedt
Subject Re: [INTERFACES] Re: Index unused with OR?
Date
Msg-id 199805141554.RAA05331@gate.va.fh-ulm.de
Whole thread Raw
In response to Re: [INTERFACES] Re: Index unused with OR?  (Hannu Krosing <hannu@trust.ee>)
List 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@fh-ulm.de
Fachhochschule Ulm  Prittwitzstr. 10   89075 Ulm
Tel.: +49 (0)731-502-8220             Fax: -8270

 Beati pauperes spiritu.


pgsql-interfaces by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [INTERFACES] Re: Index unused with OR?
Next
From: Michael Hirohama
Date:
Subject: Re: retrieving varchar size