| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | chris(dot)gamble(at)CPBINC(dot)com |
| Cc: | kleptog(at)svana(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help understanding indexes |
| Date: | 2002-06-12 15:58:32 |
| Message-ID: | 10290.1023897512@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
chris(dot)gamble(at)CPBINC(dot)com writes:
> Heres the one with the float8's with an explain.
> SELECT * FROM tdatcustomerlist WHERE float8gt(longitude,-87.09486892480946)
> AND float8lt(longitude, -87.05713307519055) AND float8gt(latitude,
> 31.095787219971054) AND float8lt(latitude, 31.124730780028944)
Try writing it in a more natural fashion:
SELECT * FROM tdatcustomerlist WHERE longitude > -87.09486892480946
AND longitude < -87.05713307519055 AND latitude > 31.095787219971054
AND latitude < 31.124730780028944
The optimizer doesn't try to do anything with function calls, only with
operators.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2002-06-12 17:16:42 | Re: [BUGS] createdb comments |
| Previous Message | Paulo Sergio Fernandes Parola (Keyword) | 2002-06-12 15:49:22 | JOIN performance + exporting/importing text files (how to do bett er than with \copy?) |