Thread: NaN values and ODBC/OLE

Hi All -

I am trying to figure out how to get 'NaN' values in a result set
through the Postgres ODBC driver and the OLE ODBC driver.  Right now
they are coming back as zeros.  Any ideas gratefully received.



________________________________________________________
Richard Wesley          Senior Software Developer            Tableau
Software
Visit: http://www.trytableau.com/now.html

> I am trying to figure out how to get 'NaN' values in a result set
> through the Postgres ODBC driver and the OLE ODBC driver.  Right now
> they are coming back as zeros.  Any ideas gratefully received.

Sorry for my ignorancy, but could you explain more detail about the value 'NaN'?  What is it that
you are doing to insert your data and can you show how the results are different from what you
expect?

Regard,

Richard Broersma Jr.

Richard Wesley wrote:
> Hi All -
>
> I am trying to figure out how to get 'NaN' values in a result set
> through the Postgres ODBC driver and the OLE ODBC driver.  Right now
> they are coming back as zeros.  Any ideas gratefully received.

The current driver doesn't handle NaN(Infinity) properly.
Do you want the fixed version ?

regards,
Hiroshi Inoue