[GENERAL] PostgreSQL with MS Query?

hat linux. Any help would be appreciated... 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

[GENERAL] Displaying a float8 as a full-length number

ELECT CAST('0.001' AS float8); float8 1e-15 (1 row) db=# SELECT to_char(CAST('0.001' AS float8), CAST('0.9' AS text)); to_char --- 0.00 (1 row) Does anyone have any suggest