JDBC and intervals
| От | Pablo Velasquez Rivas |
|---|---|
| Тема | JDBC and intervals |
| Дата | |
| Msg-id | 4027F77F.4000902@its.co.cr обсуждение исходный текст |
| Ответы |
Re: JDBC and intervals
|
| Список | 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
== ==
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
== ==
В списке pgsql-jdbc по дате отправления: