| 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: | Whole Thread | Raw Message | 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 |