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

Re: Storing and retreiving infinity timestamp values from

From: Kris Jurka <books(at)ejurka(dot)com>
To: Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Storing and retreiving infinity timestamp values from
Date: 2006-09-27 18:37:43
Message-ID: Pine.BSO.4.63.0609271315440.6334@leary2.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Wed, 27 Sep 2006, Mario Splivalo wrote:

> I have read some posts on this mailinglist concerning the infinity value
> of the timestamp data type, where it was stated that an exception is
> thrown when one attempts to read infinity value. Now, on the postgresql
> jdbc there is an entry in TODO list wich mentions adding handling of
> 'infinity' values to the jdbc documentation.
>
> Is it possible for someone to post some code here for reading/storing
> infinity timestamp values to and from postgres database?
>

See attached.  We use special constants to indicate infinity because Java 
has no equivalent.  Looking at this test output, the displayed value of 
our negative infinity value looks a little suspect and I suspect there's 
something timezone dependent going on there.  Any change to that shouldn't 
affect your code, just the constants value.

Kris Jurka

Attachment: InfTS.java
Description: text/plain (1.1 KB)

In response to

pgsql-jdbc by date

Next:From: Jeff MadisonDate: 2006-09-28 04:17:18
Subject: Switching database inside current connection
Previous:From: Mario SplivaloDate: 2006-09-26 22:47:16
Subject: Storing and retreiving infinity timestamp values from postgresdatabase

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