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.


--------------------------------------------------------------------------------
Sebestyďż˝n Zoltďż˝n AKA Memphisto		It all seems so stupid,
					it makes me want to give up. 
szoli@netvisor.hu			But why should I give up,
                                        when it all seems so stupid? 

MAKE INSTALL NOT WAR			And please avoid Necrosoft Widows



Mon, 2 Nov 1998 16:40:34 +0100 (CET)
Memphisto <szoli@netvisor.hu>
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.
>

Tue, 03 Nov 1998 10:30:51 +0100
"Jose' Soares" <jose@sferacarta.com>
Re: [GENERAL] float8 to text converter
On Tue, 3 Nov 1998, Jose' Soares wrote:

> Hi Memphisto,
> 
> If you are using v6.4 you can use CAST as:
6.4 is in beta, isn't it(currently i use 6.3.2)? Anyway thanks.


--------------------------------------------------------------------------------
Sebestyďż˝n Zoltďż˝n AKA Memphisto		It all seems so stupid,
					it makes me want to give up. 
szoli@netvisor.hu			But why should I give up,
                                        when it all seems so stupid? 

MAKE INSTALL NOT WAR			And please avoid Necrosoft Widows



Tue, 3 Nov 1998 12:35:59 +0100 (CET)
Memphisto <szoli@netvisor.hu>
Re: [GENERAL] float8 to text converter