Re: "Conversion of interval failed" on PGInterval with - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: "Conversion of interval failed" on PGInterval with
Date
Msg-id Pine.BSO.4.61.0509291820320.21525@leary.csoft.net
Whole thread Raw
In response to Re: "Conversion of interval failed" on PGInterval with  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc

On Thu, 29 Sep 2005, Kris Jurka wrote:

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

I've fixed this in cvs for the 8.1 branch.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: GSSAPI or Kerberos authentication problems
Next
From: Oliver Jowett
Date:
Subject: Re: queries against CIDR fail against 8.0.3?