Output float number with hex format

From: 沈雷 <drshenlei(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Output float number with hex format
Date: 2010-01-29 03:48:46
Message-ID: b35448351001281948q4c8d81cex240b20410cea7f1c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

In C Language, there is a way to format float numbers into a hex string by
using "%a" in printf.
eg:
the value: 1.2345 can be expressed as '0x1.3c083126e978dp+0' which is the
hex representation of a float number.

I have tried this in Postgres:
SELECT '0x1.3c083126e978dp+0'::float;
float8
--------
1.2345
(1 row)
This means that Postgres can accepty hex float as *input*. However I cannot
find any format function for *output*.
to_char(..., ...) does not have "%a"-like format. Is there any way to do
that?

Thank you in advance.

--
ShenLei

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Romano 2010-01-29 07:31:27 Re: Output float number with hex format
Previous Message Nick 2010-01-29 03:34:31 Re: Problem with query using ST_Dwithin