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

Storing and retreiving infinity timestamp values from postgresdatabase

From: Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Storing and retreiving infinity timestamp values from postgresdatabase
Date: 2006-09-26 22:47:16
Message-ID: 1159310836.18217.5.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-jdbc
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?

I'm using postgres 8.1 with latest JDBC drivers, and from the postgres
JDBC web page can be concluded that the infinity support has been added
to the driver.

	Mario
-- 
Mario Splivalo
Mob-Art
mario(dot)splivalo(at)mobart(dot)hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."



Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2006-09-27 18:37:43
Subject: Re: Storing and retreiving infinity timestamp values from
Previous:From: Jeanna GeierDate: 2006-09-26 19:38:19
Subject: Re: Beginner's Question: No pg_hba.conf entry for host...SSL Off

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