> in my test case, i have 5 passes and 9 total and 5/9
> is displayed as
>
> 0.55555555555555...
>
> should i format this in my application code, or does
> pgsql allow for formatting? i want to display 55.5%.
I would do this on the client side, but it doesn't make any particular
difference. Allows you to maintain a separation of your model from your
view.
http://www.postgresql.org/docs/8.1/static/functions-math.html
See the trunc function.