Postgres Pro
Downloads
Home   >   mailing lists

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

From Julie May
Subject Re: Displaying a float8 as a full-length number
Date
Msg-id 014e01c38dc6$9eedc710$a1d2a8c0@impsu.net
Whole thread Raw
In response to Displaying a float8 as a full-length number  (Grant Rutherford <grutherford@iders.ca>)
Responses Re: Displaying a float8 as a full-length number
List pgsql-general
Tree view 
Grant,

Cast it to numeric instead of float8.
 SELECT CAST('0.00001' AS numeric);

Julie

pgsql-general by date:

Previous
From: Grant Rutherford
Date:
Subject: Displaying a float8 as a full-length number
Next
From: Peter Eisentraut
Date:
Subject: Re: Call for Speakers / Presenters