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




---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: NaN values and ODBC/OLE

> I am trying to figure out how to get 'NaN' values in a result set =20
> through the Postgres ODBC driver and the OLE ODBC driver. Right now =20
> 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 di=
fferent from what you
expect?

Regard,

Richard Broersma Jr.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: NaN values and ODBC/OLE

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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate