|
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@xxxxxxxxxxxxxxx > To: jpablolorenzetti@xxxxxxxxxxx > CC: tgl@xxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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 |
