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