Indexes intersection

From: "Roberto de Amorim" <roberto(at)smartbit(dot)inf(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Indexes intersection
Date: 2003-04-08 12:09:07
Message-ID: 00fb01c2fdc7$a80feb50$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

Browse pgsql-general by date

  From Date Subject
Next Message EMS HiTech Team 2003-04-08 12:20:32 ANN: EMS PostgreSQL Query and PostgreSQL Extract released
Previous Message Ramesh PAtel 2003-04-08 11:22:09 Problem about Triggers and Function