"money" binary representation - Mailing list pgsql-general

From Konstantin Izmailov
Subject "money" binary representation
Date
Msg-id 72746b5e0911152007y57c7d80aq6ac442232fa37086@mail.gmail.com
Whole thread Raw
Responses Re: "money" binary representation
Re: "money" binary representation
List pgsql-general
I'm trying to read "money" field using PQgetvalue (PostgreSQL 8.3.7). The function returns 9 bytes, smth like 0h 0h 0h 0h 0h 0h 14h 0h 0h, for the value '$50.2'. I could not find description anywhere on how to convert the binary data into, for example, a double precision number.
 
Would you please help me find a method of converting binary "money" data into a double precision?
 
Thank you!

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Voting: "pg_ctl init" versus "initdb"
Next
From: John R Pierce
Date:
Subject: Re: "money" binary representation