Hi Alvaro, thank you for your answer, PG_GETARG_NUMERIC does not exist .. cant find it in the source code and when running i get undefined symbol: PG_GETARG_NUMERIC.
> Date: Tue, 22 Sep 2015 18:11:26 -0300 > From: alvhe...@2ndquadrant.com > To: jpablolorenze...@hotmail.com > CC: t...@sss.pgh.pa.us; pgsql-general@postgresql.org > Subject: Re: [GENERAL] numeric data type > > Juan Pablo L. wrote: > > thank you for your answer, the function is declared as: > > > > FUNCTION wtt_discount_account(IN in_phonenumber varchar(20),IN in_balanceid > > integer,IN in_chgval numeric(10,2)) > > > > i chose numeric because is supposed to be better for numbers/money > > operations, supposed to be exact, > > i would not want to loose precision because that is money, is there any > > other way which does not > > involve loosing precision ? thankS!! > > What you need is to use PG_GETARG_NUMERIC, then, and use a Numeric * > variable rather than float8. > > -- > Álvaro Herrera http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
