| 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 |