Postgres Pro
Downloads
Home   >   mailing lists

Indexes intersection - Mailing list pgsql-general

From Roberto de Amorim
Subject Indexes intersection
Date
Msg-id 003e01c2fd33$12b115f0$04c8a8c0@Desenvolvimento
Whole thread Raw
Responses Re: Indexes intersection  ("Jim C. Nasby" <jim@nasby.net>)
Re: Indexes intersection  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-general
Tree view 
Hi all, (please, look at and analyze the situation)

does BTree index support intersection?
please, I'm not talking about combination of queries, and yes of indexes!

for example: I have 2 indexes, the first in on (date_inclusion ,
date_cancellation ) and the other is in (date_cancellation ,
date_inclusion ).

so, when I do a query like this:
select * from mytable
where (date_inclusion <= '01/01/2003') and (date_cancellation >
'01/01/2003')

I think that PostgreSQL should use those 2 indexes and do an intersection
automatically between they

Roberto de Amorim - +55 48 346-2243
Software engineer at SmartBit Software
roberto@smartbit.inf.br

pgsql-general by date:

Previous
From: jonathan.nichols@sbcglobal.net (Jonathan Nichols)
Date:
Subject: Covariance Function in Postgresql??
Next
From: "Nikolaus Dilger"
Date:
Subject: Re: [ADMIN] Trying to Tunning DB