Re: about function overload,a bug?

cncinfo@126.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