Re: possible ODBC bug with '-infinity' - Mailing list pgsql-odbc

From Richard Broersma Jr
Subject Re: possible ODBC bug with '-infinity'
Date
Msg-id 160989.65498.qm@web31805.mail.mud.yahoo.com
Whole thread Raw
In response to Re: possible ODBC bug with '-infinity'  (Andrei Kovalevski <andyk@commandprompt.com>)
Responses Re: possible ODBC bug with '-infinity'  (Andrei Kovalevski <andyk@commandprompt.com>)
List pgsql-odbc
--- On Mon, 12/3/07, Andrei Kovalevski <andyk@commandprompt.com> wrote:

> Also all Microsoft applications notify ODBC driver
> by setting additional parameter during initialization. I
> think ADO requests 'inifinity' value as SQL_C_CHAR and sure
> it doesn't expect it to be 'infinity'.

Actually, postgresql doesn't actually have a (+/-) infinity value. Notice:
http://www.postgresql.org/docs/8.3/static/datatype-datetime.html#AEN4999

+infinity = 5874897 AD
-infinity = 4713 BC

so the problem must be that ADO doesn't know what to do with dates as small as 4713 BCE.

pgsql-odbc by date:

Previous
From: Andrei Kovalevski
Date:
Subject: Re: possible ODBC bug with '-infinity'
Next
From: Andrei Kovalevski
Date:
Subject: Re: possible ODBC bug with '-infinity'