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