Well don't I feel silly! Tom, thank-you for the help - I'll try and get my code debugged before bothering you again....
On 2/07/10 12:51 AM, "Tom Lane" <t...@sss.pgh.pa.us> wrote: > "" <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
