| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | emergency(dot)shower(at)gmail(dot)com, pgsql-jdbc(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Subject: | Re: Timestamp weirdness |
| Date: | 2005-07-26 14:20:42 |
| Message-ID: | 42E646BA.2030008@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Kevin Grittner wrote:
> I assume that the behavior of the server when receiving a timestampz
> within the protocol couldn't be changed to match the handling of a
> literal without breaking significant existing code.
(One more time!)
The parsing of timestamptz is just fine, it's the cast to timestamp that
breaks things.
If we get the server to infer a type for the parameter rather than
explicitly specifying it as timestamptz, then we can avoid that cast.
Then things don't break.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2005-07-26 14:28:10 | Re: Timestamp weirdness |
| Previous Message | Peter.Zoche | 2005-07-26 14:17:19 | Re: SQLException and error code |