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

Problems with infinity

From: Oliver Siegmar <o(dot)siegmar(at)vitrado(dot)de>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problems with infinity
Date: 2005-01-13 13:19:00
Message-ID: 200501131419.00993.o.siegmar@vitrado.de (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

I'm using PostgreSQL 7.4.6 with pg74.215.jdbc3.jar and have trouble with 
infinite timestamp values.

org.postgres relevant Trace:

Caused by: org.postgresql.util.PSQLException: Bad Timestamp Format at 0 in 
9999-01-01
at 
org.postgresql.jdbc1.AbstractJdbc1ResultSet.toTimestamp(AbstractJdbc1ResultSet.java:1188)
at 
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getTimestamp(AbstractJdbc1ResultSet.java:381)
at 
org.postgresql.jdbc1.AbstractJdbc1ResultSet.getTimestamp(AbstractJdbc1ResultSet.java:541)


Furthermore, in your TODO list I read "The conversion to/from datatypes 
supporting infinity is silly because Java doesn't have a similar concept. 
Throw an exception instead.".

That's really bad. I can't change the database content because several stored 
procedures are based on infinite timestamp values.

Of course I understand that conversion infinite from/to 9999-01-01 or 
0001-01-01 is silly...but its better than being forced to use another 
language to talk to the database, isn't it?


Cheers,
Oliver

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-01-13 13:42:07
Subject: Re: Problems with infinity
Previous:From: Oliver JowettDate: 2005-01-12 23:54:08
Subject: Re: Ampersands in the output...

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