Exponential display of values

From: HK <harikrishnan(at)midascomm(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Exponential display of values
Date: 2003-08-05 11:19:57
Message-ID: Pine.LNX.4.33.0308051642440.2520-100000@dipper.midascomm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-08-05 14:22:40 Re: Permission error
Previous Message Carmical Casey 2003-08-05 11:15:19 Permission error