Re: about function overload,a bug?

[Oliver Jowett <oliver(at)opencloud(dot)com>]

cncinfo(at)126(dot)com wrote:

> It seems "timestamp without time zone" is same as "character varying" in
> jdbc,so jdbc invoke wrong function.

Unfortunately the JDBC driver must pass timestamp parameters without 
type data and let the server infer the correct type to use (this is 
necessary to have both "timestamp with time zone" and "timestamp without 
time zone" operate correctly).

In your case the server is inferring the wrong type for what you want.

An explicit cast in your query may fix it.

-O