JDBC and intervals

From: Pablo Velasquez Rivas <pvelasquez(at)its(dot)co(dot)cr>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC and intervals
Date: 2004-02-09 21:11:27
Message-ID: 4027F77F.4000902@its.co.cr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ??

Thanks for any help.
== ==
Pablo A. Velasquez Rivas
Computer Science Engineer
== ==

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2004-02-09 23:34:49 Re: Use of instanceOf
Previous Message Tom Ansley 2004-02-09 17:17:49 unsubscribe