Re: intervals and jdbc

Joseph,

What do you want it to return, postgres is assuming you want an
interval, but there is no jdbc interval type. What are you expecting it
to return?

Dave
On Thu, 2002-12-05 at 22:15, Joseph Shraibman wrote:
> Try this:
> select current_timestamp - '2002-12-05 22:14'::timestamp;
>
> Dave Cramer wrote:
> > Joseph,
> >
> > Can you send me a test case to demonstrate what you are trying to do?
> >
> > Dave
> > On Thu, 2002-12-05 at 21:45, Joseph Shraibman wrote:
> >
> >>If I try to get an interval from postgres via jdbc I get:
> >>
> >>No class found for interval
> >>         at
> >>org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connection.java:693)
> >>         at
> >>org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:117)
> >>         at
> >>org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:147)
> >>
> >>Why can't the interval just be returned as a String?
> >>
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 5: Have you checked our extensive FAQ?
> >>
> >>http://www.postgresql.org/users-lounge/docs/faq.html
--
Dave Cramer <Dave@micro-automation.net>