Getting a primitive numeric value from "DatumGetNumeric"? - Mailing list pgsql-general

Hi,

I’m writing a C extension for PostgreSQL. One possible input datatype for my function is a numeric array, e.g.
ARRAY[[1.5,2.5],[3.5,4.5]].I can use “DatumGetNumeric” to extract a “Numeric” data type from the data, but at some
pointI need to convert this to a number (e.g. double) so that I can do mathy things with it. How does one convert a
“Numeric”to, say, a double? 

I have a workaround in that I can pass this to my function:

ARRAY[[1.5,2.5],[3.5,4.5]]::float8[]

but I’d rather have the code do that instead of bothering the user to remember that.

Thanks,
Demitri