Re: [Dbdpg-general] benchmarking old Pg and DBD::Pg

On Fri, 2005-04-08 at 14:12 -0400, Vlad wrote:
> we've noticed that too here and quick explanation is - with the new
> "prepare" implementation, the query get prepared on the server side,
> which is good; the problem is that all of the bind values passed to
> the sql server during execute call are in form of ***varchar***, i.e.
> even if a field is of int type in postgresql table, DBD::Pg passes
> your bind value as char - as a result, postgresql doesn't use indexes.

A work around would be in the sql to cast the param to the appropriate
type. 

EG: SELECT * FROM Person WHERE personid = %::int




-- 
David Stanaway <david@stanaway.net>