Re: Request to clarify on sql_numeric datatype

Raghavendra Reddy <raghavendrar(at)aztec(dot)soft(dot)net> writes:
> While inserting numeric data type into a table can you please let me
> know how you are storing the value in the database.

>From src/include/utils/numeric.h:

/*
* The Numeric data type stored in the database
*
* NOTE: by convention, values in the packed form have been stripped of
* all leading and trailing zero digits (where a "digit" is of base NBASE).
* In particular, if the value is zero, there will be no digits at all!
* The weight is arbitrary in that case, but we normally set it to zero.
*/
typedef struct NumericData
{
int32 varlen; /* Variable size (std varlena header) */
int16 n_weight; /* Weight of 1st digit */
uint16 n_sign_dscale; /* Sign + display scale */
char n_data[1]; /* Digits (really array of NumericDigit) */
} NumericData;

See also the comments at the top of src/backend/utils/adt/numeric.c.

regards, tom lane