Re: Something wrong with binding timestamp values - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: Something wrong with binding timestamp values
Date
Msg-id 216.1165433274@sss.pgh.pa.us
Whole thread Raw
In response to Re: Something wrong with binding timestamp values  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-jdbc
Peter Eisentraut <peter_e@gmx.net> writes:
> OK, I found out that it used to bind such values as timestamptz, which failed
> when the receiving type was a timestamp (without time zone).  But it should
> work the other way around, namely binding them as timestamp without time
> zone, because that can be casted implicitly to timestamptz.

Only for rather small values of "work" I'm afraid --- in particular,
that would cause any timezone specification in the input string to
be ignored, which is OK for timestamp without tz but surely not OK
for the other.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Something wrong with binding timestamp values
Next
From: "Ido M. Tamir"
Date:
Subject: copy patch in new driver