Re: Improving performance with a Function instead of a - Mailing list pgsql-general

From Kris Jurka
Subject Re: Improving performance with a Function instead of a
Date
Msg-id Pine.LNX.4.33.0402050309540.20755-100000@leary.csoft.net
Whole thread Raw
In response to Re: Improving performance with a Function instead of a  (Hadley Willan <hadley.willan@deeperdesign.co.nz>)
List pgsql-general

On Thu, 5 Feb 2004, Hadley Willan wrote:

> Thanks, but I don't believe this to be a problem because my JDBC layer
> when I construct the query is using setObject( parameter, getId,
> Types.BIGINT )
>
> so by the time it arrives at the database that cast should have already
> occured?
>

The JDBC driver will not do any casting for you.  The cross type indexing
problem is is a backend issue and has been addressed in the cvs version,
but this has long been a problem for JDBC users.

Kris Jurka


pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Can LIKE use indexes or not?
Next
From: "John Sidney-Woollett"
Date:
Subject: Re: Can LIKE use indexes or not?