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: alvherre@2ndquadrant.com
> To: jpablolorenzetti@hotmail.com
> CC: tgl@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