Re: Improving performance with a Function instead of a

From: Kris Jurka <books(at)ejurka(dot)com>
To: Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz>
Cc: Mike Mascari <mascarm(at)mascari(dot)com>, PGSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Improving performance with a Function instead of a
Date: 2004-02-05 08:41:06
Message-ID: Pine.LNX.4.33.0402050309540.20755-100000@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2004-02-05 08:58:50 Re: Can LIKE use indexes or not?
Previous Message David Garamond 2004-02-05 08:30:07 Can LIKE use indexes or not?