C Function with Arrays Question

Поиск
Список
Период
Сортировка
От Achilleus Mantzios
Тема C Function with Arrays Question
Дата
Msg-id 02032614000004.09965@pc216
обсуждение исходный текст
Ответы Re: C Function with Arrays Question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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@dynacomtm.com
        rnd@gatewaynet.com


В списке pgsql-general по дате отправления:

Предыдущее
От: "Gyorgy Molnar"
Дата:
Сообщение: PL/pgsql return more than one values
Следующее
От: "Arsalan Zaidi"
Дата:
Сообщение: Speed diff cause by multi-byte support