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 |