Skip site navigation (1) Skip section navigation (2)

Re: "Conversion of interval failed" on PGInterval with

From: Kris Jurka <books(at)ejurka(dot)com>
To: Jean-Pierre Pelletier <pelletier_32(at)sympatico(dot)ca>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "Conversion of interval failed" on PGInterval with
Date: 2005-09-29 21:12:18
Message-ID: Pine.BSO.4.61.0509291610170.29679@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Thu, 29 Sep 2005, Jean-Pierre Pelletier wrote:

> I've got PSQLException "Conversion of interval failed"
> throwned when trying to read an interval larger than
> 100 hours (101:12:00) into a PGInterval object.
> It was running fine with the build 312 jdbc3 driver.
>

OK, this is because 8.1 has separated hours and days in an interval 
definition, previously 100 hours turned into '4 days 4 hours', but in 8.1 
it remains 100 hours.  I'll look at a fix...

Kris Jurka

In response to

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-09-29 21:14:22
Subject: Re: setObject(col, blob) throws PSQLException
Previous:From: Jean-Pierre PelletierDate: 2005-09-29 20:45:17
Subject: "Conversion of interval failed" on PGInterval with 8.1dev-401.jdbc3.jar

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group