From: | Achilleus Mantzios <rnd(at)gatewaynet(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | C Function with Arrays Question |
Date: | 2002-03-26 12:00:00 |
Message-ID: | 02032614000004.09965@pc216 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Hi,
Is there a way of accessing _float8 (float8[]) values inside of
a server-side C function??
For instance imagine:
# \d formulatest
Table "formulatest"
Column | Type | Modifiers
---------+--------------------+-----------
formula | double precision[] |
# insert into formulatest values('{2.3,3.3}');
# insert into formulatest values('{4.3,5.3}');
and then write a C function named formula
float8 *formula(x,formarray)
float8 *x;
_float8 *formarray; /* This is serious part of the question!! */
{
float8 *result = (float8 *) malloc(sizeof(float8));
/* what happened to palloc in pgsql 7.2??,
* Also what happened to postgres.h??
*/
*result = *formarray[0];
return result;
/* This is pseudo code to demonstrate the question */
}
Thanx.
P.S.
7.2 runs quite stable on my Linux 2.4.7.
JDBC built without a problem, and also supports Arrays (at least one
dimension for sure).
--
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel: +30-10-8981112
fax: +30-10-8981877
email: it(at)dynacomtm(dot)com
rnd(at)gatewaynet(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Arsalan Zaidi | 2002-03-26 12:22:12 | Speed diff cause by multi-byte support |
Previous Message | Denis Gasparin | 2002-03-26 10:06:48 | Altering a CHAR(4) column CHAR(5) changing pg_attribute |
From | Date | Subject | |
---|---|---|---|
Next Message | Arguile | 2002-03-26 13:51:21 | Re: Cleaning up template 1 |
Previous Message | Achilleus Mantzios | 2002-03-26 08:12:12 | Arrays Design Question |