JDBC and intervals - Mailing list pgsql-jdbc

Hi.

I'm trying to get an interval from a postgresql query.

I was using jdbc for postgresql 7.3.x, and my query was:

ResultSet.executeQuery("SELECT (final_date - initial_date) FROM some_table") ;

When I did something like this:
System.out.println(resultSet.getObject(1)),  , I got the message: " Error = No class found for interval"

So, I tried upgrating to postgresql 7.4.x, and if I do
System.out.println(resultSet.getObject(1)) ,  I get : null.

So, is there a way to get an interval from a postgresql query ?, or am I doing something wrong ??


==                                 ==
   Pablo A. Velasquez Rivas
Computer Science Engineer
==                                 ==