Re: Strange discrepancy in query performance...

I agree that this is a bug in JasperReports. I've been stepping throgh
their code to determine where the paramter type is set to
'java.lang.String', but have not yet figured out how their Java API will
allow me to override that with 'java.lang.Integer' or something more
appropriate.

If I figure something out, I'll post to the list.

Regards,
jason

Tom Lane wrote:
> Hmm ... if Postgres were just given the parameter symbol with no type
> information, I believe it would have assumed it was bigint (or in
> general, the same type as what it's being compared to). So your
> problem suggests that Jasper is deliberately telling the backend that
> that parameter is of type text. If that's coming from something you
> did in your code, you probably ought to change the code. If not,
> it seems like a bug/omission in Jasper.
>
> regards, tom lane
>