Postgres Pro
Downloads
Home   >   mailing lists

Re: Does PGInterval class handle iso_8601 intervalstyle? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Does PGInterval class handle iso_8601 intervalstyle?
Date
Msg-id alpine.BSO.2.03.1503271051340.13625@ejurka.com
Whole thread Raw
In response to Does PGInterval class handle iso_8601 intervalstyle?  (Adam Mackler <psql-jdbc@mackler.org>)
List pgsql-jdbc
Tree view 

On Thu, 26 Mar 2015, Adam Mackler wrote:

> Is is possible to use the PGInterval class to parse interval literals
> in the format that a server with intervalstyle set to iso_8601
> produces?  If so, how?  If not, why not, and why is no exception
> raised when trying to do so?
>

No it's not currently possible.  The PGInterval class was written prior to
the intervalstyle parameter being added in 8.4 and was never updated to
account for intervals in 8601 format.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Jeremy Whiting
Date:
Subject: Re: Multi insert statement and getUpdateCount().
Next
From: Dave Cramer
Date:
Subject: Re: Resurrected thread: Speed improvement - Group batch Insert - Rewrite the INSERT at the driver level (using a parameter)