Re: about function overload,a bug?

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: cncinfo(at)126(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: about function overload,a bug?
Date: 2007-10-28 20:44:18
Message-ID: 4724F4A2.1080601@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message cncinfo@126.com 2007-10-29 03:29:23 Re: about function overload,a bug?
Previous Message Marek Lewczuk 2007-10-28 19:28:59 Re: AbstractJdbc2Array - another patch