Masterprojekt Naumann1 escribió: > Dear Dev-List, > > 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. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers