"" <myk...@gmail.com> writes:
> Some needless speculation:
> 0.75 = 3F400000 (as IEEE 32-bit float)
> 0.75 = 3FE8000000000000 (as IEEE 64-bit float)
> 1.812500 = 3FE80000 (as returned by PQexecParams)
> i.e. the return value is the first 32-bits of the 64-bit representation of
> the correct value.

Well, yeah.  You declared the column as float8, not float4:

>       res = PQexec(conn, "CREATE TABLE testtbl( Intgr int4, Flt float8, 
> PRIMARY
KEY ( Intgr ));");

                        regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to