Re: [PERFORM] Use of BETWEEN with identical values

2009-09-18 Thread Robert Haas
On Thu, Sep 17, 2009 at 5:02 PM, André Volpato wrote: > André Volpato escreveu: >> >> (...) >> >> (Postgres 8.3.6, Debian Linux 2.6.18-6-amd64) >> >> (...) > >> Condition 1: >> # select fat_referencia from bds_contratacao_fatura where fat_referencia >> BETWEEN 200908 AND 200908; >> Index Scan usin

Re: [PERFORM] Use of BETWEEN with identical values

2009-09-17 Thread André Volpato
André Volpato escreveu: (...) (Postgres 8.3.6, Debian Linux 2.6.18-6-amd64) (...) Condition 1: # select fat_referencia from bds_contratacao_fatura where fat_referencia BETWEEN 200908 AND 200908; Index Scan using ibds_contratacao_fatura1 on bds_contratacao_fatura (cost=0.00..5.64 rows=1 wi

[PERFORM] Use of BETWEEN with identical values

2009-09-17 Thread André Volpato
Hi, Is there any downsides of using BETWEEN two identical values ? (Postgres 8.3.6, Debian Linux 2.6.18-6-amd64) The problem is in this index: CREATE INDEX ibds_contratacao_fatura1 ON bds_contratacao_fatura USING btree (fat_referencia); "fat_referencia" is a field that tells year and month