On 2009-11-16, Konstantin Izmailov <pgfizm@xxxxxxxxx> wrote: > --000e0cd5d09230ff7d04787526aa > Content-Type: text/plain; charset=ISO-8859-1 > > 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. money is a 64 bit integer representing a number of cents, it appears to be big-endian byte order on ypur system it is deprecated and should not be used in new applications, use some sort of numeric instead. > Would you please help me find a method of converting binary "money" data > into a double precision? floating point is not recomended for financial calculations, but dividing the integer value by 100.0 should get you there. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
