Re: Timestamp weirdness - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Timestamp weirdness
Date
Msg-id 42E6C49B.4040404@opencloud.com
Whole thread Raw
In response to Timestamp weirdness  ("emergency.shower@gmail.com" <emergency.shower@gmail.com>)
List pgsql-jdbc
Kevin Grittner wrote:

> My question (not well stated, I'm sure) was whether there is a way to
> know, on the server, at the point of handling the timestampz from the
> protocol stream, that it is going to be assigned to a TIMESTAMP WITHOUT
> TIME ZONE and use literal assignment rules (i.e., ignore the time zone
> info) instead of the cast rules.  The next question was whether this
> would break existing code.

As I said:

>>>>Oliver Jowett <oliver@opencloud.com> 07/26/05 9:20 AM >>>

> 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

pgsql-jdbc by date:

Previous
From: Scott Goldstein
Date:
Subject: Client Connection vs. JDBC Connections vs. Postgres processes
Next
From: Oliver Jowett
Date:
Subject: Re: Timestamp Summary