Re: numeric data type

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(at)2ndquadrant(dot)com
> To: jpablolorenzetti(at)hotmail(dot)com
> CC: tgl(at)sss(dot)pgh(dot)pa(dot)us; pgsql-general(at)postgresql(dot)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