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