Displaying a float8 as a full-length number

Hello,

I need to get a float8 to display as a number

db=# SELECT CAST('0.00001' AS float8);
  float8
--------
   1e-05
(1 row)


I need this to return 0.00001 instead.  I know about the to_char
function, but this seems to truncate the number after fourteen digits of
precision:


db=# SELECT CAST('0.000000000000001' AS float8);
  float8
--------
   1e-15
(1 row)

db=# SELECT to_char(CAST('0.000000000000001' AS float8),
CAST('0.9999999999999999999999999' AS text));
       to_char
-------------------
   0.00000000000000
(1 row)


Does anyone have any suggestions?

Thanks,
Grant


--
Grant Rutherford
Iders Incorporated
600A Clifton Street
Winnipeg, MB
R3G 2X6
http://www.iders.ca
tel: 204-779-5400 ext 36
fax: 204-779-5444
================================
Iders Incorporated: Confidential
================================
Note: This message is intended solely for the use of the designated
recipient(s) and their appointed delegates, and may contain
confidential information.  Any unauthorized disclosure, copying or
distribution of its contents is strictly prohibited.  If you have
received this message in error, please destroy it and advise the sender
immediately by phone, Email or facsimile.