Postgres Pro
Downloads
Home   >   mailing lists

Re: Get double values from binary cursor - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: Get double values from binary cursor
Date
Msg-id 15776.1134669740@sss.pgh.pa.us
Whole thread Raw
In response to Get double values from binary cursor  (Oleg Semykin <oss-dev@rambler.ru>)
List pgsql-interfaces
Tree view 
Oleg Semykin <oss-dev@rambler.ru> writes:
> i want to get a double values from binary cursor

>     PQclear( PQexec(conn, "begin; declare my_cur binary cursor for 
> select 123.123;") );

This is most likely returning a numeric, not a float8.  Try casting
the value to float8 explicitly.
        regards, tom lane

pgsql-interfaces by date:

Previous
From: Oleg Semykin
Date:
Subject: Get double values from binary cursor
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Obtaining information on the schema of tables which