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
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 |