Alvaro Herrera 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers