On Fri, Sep 12, 2008 at 12:50 PM, Hengky Lie <[EMAIL PROTECTED]> 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) -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
