Exponential display of values - Mailing list pgsql-novice

From HK
Subject Exponential display of values
Date
Msg-id Pine.LNX.4.33.0308051642440.2520-100000@dipper.midascomm.com
Whole thread Raw
Responses Re: Exponential display of values
List pgsql-novice
Hi all,
  I have a numeric field in the table which denotes the bit error rate.
So i want to display the values in a normalised form i.e   0.xy e-z
  The problem is if the value is something like 0 or 0.01, it is displayed as
the same. How do i display all values in the same format, so that visual
comparison can be done easily in the front end i am providing.
  I have a gut feeling it can be done, but am unable to figure out how.
Plz help me.
TIA.

Regards,
Hari.


pgsql-novice by date:

Previous
From: "Carmical Casey"
Date:
Subject: Permission error
Next
From: Tom Lane
Date:
Subject: Re: Permission error