'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 ?
|
| Список | 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 по дате отправления: