Hari,
> 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.
Please see the documentation on "to_char()"
Online Docs --> User Documentation --> Functions and Operators --> Formatting
Functions.
--
Josh Berkus
Aglio Database Solutions
San Francisco
