DBD::ODBC and infinity timestamp

Started by ag20over 24 years ago2 messagesgeneral
Jump to latest
#1ag20
ag20@co.merced.ca.us

When I return a timestamp with a value of 'infinity' or '-infinity' through
PostgreSQL ODBC driver 7.01.00.06 and DBD::ODBC and DBI to Perl I am getting
the current date timestamp. Is this a driver thing? Or is it something with
DBD::ODBC DBI. This is all running under windows with ActiveState's Perl,
DBI and DBD::ODBC. I don't have the problem under linux using DBD::Pg.

#2Hiroshi Inoue
Inoue@tpf.co.jp
In reply to: ag20 (#1)
Re: DBD::ODBC and infinity timestamp

ag20 wrote:

When I return a timestamp with a value of 'infinity' or '-infinity' through
PostgreSQL ODBC driver 7.01.00.06 and DBD::ODBC and DBI to Perl I am getting
the current date timestamp. Is this a driver thing?

Seems a ODBC driver thing.
However ODBC couldn't handle (-)infinity timestamp values.
What should ODBC driver return ?

regards,
Hiroshi Inoue