numeric data type

From: Juan Pablo L(dot) <jpablolorenzetti(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: numeric data type
Date: 2015-09-22 19:48:55
Message-ID: DUB130-W782DF3194327931E9B755AD9450@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, i m writing a C module (extension), the procedure has a parameter that is of type numeric,
inside the function i can not read the parameter or so it seems, this what is do:

float8 db_balance,in_chgval;

in_chgval = PG_GETARG_FLOAT8(2);

elog(INFO,"in_chgval = %0.2f",in_chgval);

The above elog, always shows cero, more over, i m also trying to read a
numeric from the database and substracted from the in_chgval parameter,
the operation always gives 0,, so apparently i can not read a numeric from a
data base:

db_balance = DatumGetFloat8(SPI_getbinval(SPI_tuptable->vals[0],SPI_tuptable->tupdesc,1,&is_null));

elog(INFO,"db_balance(%f) - in_chgval(%f) = %f",db_balance,in_chgval,(db_balance - in_chgval));

it shows all 0 ..... please any advise would be really appreciated. thank you!!

In response to

  • numeric at 2015-09-20 00:49:05 from Juan Pablo L.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-09-22 20:07:36 Re: numeric data type
Previous Message Steve Crawford 2015-09-22 17:45:57 Re: Queuing query