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.