the types are integer.
excellent!
you saved my weekend.
Uwe
Uwe Bartels
Systemarchitect - Freelancer
mailto: uwe.bart...@gmail.com
tel: +49 172 3899006
profile: https://www.xing.com/profile/Uwe_Bartels
website: http://www.uwebartels.com
On 18 February 2011 15:58, Kevin Grittner wrote:
> Uwe B
Uwe Bartels wrote:
> I have a java application which generates inperformant query
> plans.
> Index Cond: ((lat >= $3) AND (lat <= $4) AND (lon >= $1) AND (lon
> <= $2))
> Filter: (((lon)::double precision >= $1) AND ((lon)::double
> precision <= $2) AND ((lat)::double precision >= $3) AND
>
Hi,
I have a java application which generates inperformant query plans.
I checked the query plan from the java application via auto_explain module
and I compared the plan which I generate in psql.
They are different and I have no idea how I can convince the java
application to use the index.
the
