| 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: | Whole Thread | Raw Message | 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
== ==
| 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 |