'infinity'::timestamp not translated correctly using ODBC v7.01.00.10 ?

Поиск
Список
Период
Сортировка
От Kristis Makris
Тема 'infinity'::timestamp not translated correctly using ODBC v7.01.00.10 ?
Дата
Msg-id 1017359263.1070.10.camel@leonidas
обсуждение исходный текст
Ответ на Re: Difference between ODBCdirect Connection and Pass-through-query  (Cedar Cox <cedarc@visionforisrael.com>)
Ответы Re: 'infinity'::timestamp not translated correctly using ODBCv7.01.00.10 ?  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-odbc
Hello,

I'm issuing the following SQL statement through psql:

mydb=# select 'infinity'::timestamp as reply;
  reply
----------
 infinity
(1 row)


When I try to issue the same statement through VC++ in the following
piece of code I get back "2002-03-28 00:00:00". Is infinity somehow
effectively translated into now()::date || "00:00:00" by the driver?

if (db.CanTransact())
    db.BeginTrans();

CRecordset rsNewRecords(&db);

strStmt = "SELECT 'infinity'::timestamp as reply";
rsNewRecords.Open(CRecordset::forwardOnly, strStmt);

while (!rsNewRecords.IsEOF())
    {
        rsNewRecords.GetFieldValue("reply", retval);
        rsNewRecords.MoveNext();
    }


I'm actually calling a backend function that attempts to make a date
estimate, and happens to return "infinity" in some cases, but so far
I've determined that 'infinity' is never reported as "infinity".

Thanks,
-Kristis


В списке pgsql-odbc по дате отправления:

Предыдущее
От: DI Hasenöhrl
Дата:
Сообщение: Re: Difference between ODBCdirect Connection and Pass-through-query
Следующее
От: DI Hasenöhrl
Дата:
Сообщение: ODBCdirect and MsAccess97