From: | "Jose' Soares" <jose(at)sferacarta(dot)com> |
---|---|
To: | Memphisto <szoli(at)netvisor(dot)hu> |
Cc: | PostgreSQL general mailinglist <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [GENERAL] float8 to text converter |
Date: | 1998-11-03 09:30:51 |
Message-ID: | 363ECD4B.E7294A8D@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares | 1998-11-03 10:09:05 | Re: [GENERAL] Transaction aborted? |
Previous Message | Johann Hueppeler | 1998-11-03 08:42:22 | [Fwd: postgreSQL v6.4 - foreign key] |
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 1998-11-03 11:07:44 | Re: [HACKERS] A small problem with the new inet and cidr types |
Previous Message | Michael Meskes | 1998-11-03 09:27:19 | update and select |