| 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: | Whole Thread | Raw Message | 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
| 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 |