Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruno Wolff III
Subject Re: Displaying a float8 as a full-length number
Date
Msg-id 20031008182920.GA31260@wolff.to
Whole thread Raw
In response to Displaying a float8 as a full-length number  (Grant Rutherford <grutherford@iders.ca>)
List pgsql-general
Tree view 
On Wed, Oct 08, 2003 at 12:48:09 -0500,
  Grant Rutherford <grutherford@iders.ca> wrote:
>
> 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:

How about casting it to numeric? It seemed to work reasonably for me,
but I only tried one case.

pgsql-general by date:

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