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