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 23:21:12
Message-ID: Pine.BSO.4.61.0509291820320.21525@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-09-29 23:22:13 Re: queries against CIDR fail against 8.0.3?
Previous Message Kris Jurka 2005-09-29 23:19:02 Re: GSSAPI or Kerberos authentication problems