cio198@plasa.com (cio198) writes:
> The problem is the numeric data in the view isn't limited to
> numeric(9,2) instead it become numeric(65535, 65531).
It should look like plain, unrestricted "numeric". Whatever is showing
you those bogus precision/scale fields is wrong. What client software
are you using anyway?
> Is there any way i can restrict it to numeric (9,2)
If you really want (9,2) and not just plain numeric, you can cast the
results of the sum operations to numeric(9,2).
regards, tom lane