View Single Post

   
  #2 (permalink)  
Old 04-15-2008, 11:39 PM
Kris Jurka
 
Posts: n/a
Default Re: "Conversion of interval failed" on PGInterval with



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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote