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