Re: Decimal values in - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Decimal values in
Date
Msg-id 32182.1392655160@sss.pgh.pa.us
Whole thread Raw
In response to Re: Decimal values in  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Masterprojekt Naumann1 escribi�:
>> inside execProcnode.c's ExecProcNode method we want to extract the value of
>> a tuple for a specific attribute. This works great for integers and
>> strings, but we are not able to figure out how to do this for floating
>> point numbers. Below is some example code snippet to show our problem:

> "DECIMAL_OID" (you probably mean NUMERICOID) points to datatype numeric,
> which is not floating point but a variable length datatype with its own
> special encoding for storage.  If you want floating point you need
> FLOAT4OID and FLOAT8OID, and columns created with types float and
> "double precision", respectively.

Also, you should not be using casts, but the appropriate DatumGetXXX
macro.  In some cases those reduce to a cast, but your code ought not
assume that.
        regards, tom lane



pgsql-hackers by date:

Previous
From: "MauMau"
Date:
Subject: Re: Do you know the reason for increased max latency due to xlog scaling?
Next
From: Andres Freund
Date:
Subject: Re: Do you know the reason for increased max latency due to xlog scaling?