BUG #3634: Numeric and Array Data Type

The following bug has been logged online:

Bug reference: 3634
Logged by: zhuge
Email address: zhuge(at)Rinaix(dot)cn
PostgreSQL version: 8.1.9
Operating system: Linux
Description: Numeric and Array Data Type
Details:

To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

Thank you for your help. You are right.

Today, I write a function, get_order_total_amount(_order_code_ text), which
reads the order table and compute the amount and return the amount. The
amount belongs to "numeric" data type, but the C function has no relative
numeric data type. If I write the script like the following:

CREATE OR REPLACE FUNCTION get_order_total_amount(text)
RETURNS numeric --> Here, if float8, then right
AS 'libdpa-pg_sql_c_func', 'get_order_total_amount'
LANGUAGE C STRICT;

then error occurs . The C function returns double (i.e. float8). How can I
let the C function return the numeric data type?

And I have another question: How can I access the array argument elements
(passed from SQL script like the following) in C function?

CREATE OR REPLACE FUNCTION get_order_total_amount(text[])
RETURNS numeric
AS 'libdpa-pg_sql_c_func', 'get_order_total_amount'
LANGUAGE C STRICT;

Note that the argument, text[], is array type different from the above
argument, text. In C function, how to access the array elements?

Please help me.

Thank you agian.

zhuge