Indexes intersection

From: "Roberto de Amorim" <rbamorim(at)ig(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Cc: <suporte(at)dbexperts(dot)com(dot)br>
Subject: Indexes intersection
Date: 2003-04-07 18:25:31
Message-ID: 003e01c2fd33$12b115f0$04c8a8c0@Desenvolvimento
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(at)smartbit(dot)inf(dot)br

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nolan 2003-04-07 18:35:15 Age function
Previous Message Jan Wieck 2003-04-07 18:22:42 Re: [GENERAL] psql in shell