On Fri, Sep 12, 2008 at 12:50 PM, Hengky Lie <hengkyliwandouw(at)gmail(dot)com> wrote:
> Dear Richard,
>
> Sorry for that :) and thanks for your tips, but it didn't solve my problem.
> Maybe because my postgresql knowledge limitation. I have tried your
> suggestion, my view like this :
Put parens around the whole thing, like:
(tbltransaksi.hargapokok * tbltransaksi.keluar)::numeric(2,0) AS modal
Otherwise you're really doing this:
tbltransaksi.hargapokok::numeric * tbltransaksi.keluar::numeric(2,0) AS modal
and when you multiply a numeric times a numeric(2,0) you get a
numeric, not a numeric(2,0)