Re: [GENERAL] float8 to text converter

Hi Memphisto,

If you are using v6.4 you can use CAST as:

prova=> select cast('1.7976931348623e+308'::float8 as text);
?column?
--------------------
1.7976931348623e+308
(1 row)

or:

prova=> select cast(f as text) from a;
text
----------------------
4714-11--2147483624 BC <---
4714-11--2147483624 BC <---
(2 rows)

Ooops! that seems like a bug.

prova=> select f from a;
f
--------------------
1.7976931348623e+308
1.7976931348623e+308
(2 rows)

Jose'

Memphisto wrote:
>
> Hi,
>
> I'd like to know if there's an operator that converts from float8 to
> text. It should be because PGSQL can print a float8 number.
>