Re: Something wrong with binding timestamp values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Something wrong with binding timestamp values
Date: 2006-12-06 19:27:54
Message-ID: 216.1165433274@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Peter Eisentraut <peter_e(at)gmx(dot)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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Ido M. Tamir 2006-12-07 15:43:06 copy patch in new driver
Previous Message Peter Eisentraut 2006-12-06 15:57:11 Re: Something wrong with binding timestamp values