Re: Displaying a float8 as a full-length number - Mailing list pgsql-general

From Grant Rutherford
Subject Re: Displaying a float8 as a full-length number
Date
Msg-id 3F8458B1.9070009@iders.ca
Whole thread Raw
In response to Re: Displaying a float8 as a full-length number  ("Julie May" <julie@ccorb.com>)
List pgsql-general
Julie May wrote:

>Grant,
>
>Cast it to numeric instead of float8.
> SELECT CAST('0.00001' AS numeric);
>
>Julie
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
>
Thanks, that worked perfectly.

--
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.




pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Displaying a float8 as a full-length number
Next
From: Al Hulaton
Date:
Subject: Re: Humor me: Postgresql vs. MySql (esp. licensing)