Re: making functions take arrays - Mailing list pgsql-general

From Tom Lane
Subject Re: making functions take arrays
Date
Msg-id 19197.982001461@sss.pgh.pa.us
Whole thread Raw
In response to making functions take arrays  (Kyle <kaf@nwlink.com>)
List pgsql-general
Kyle <kaf@nwlink.com> writes:
> Is it possible to make a compiled C function take an array as an
> argument?

Sure, although disassembling the array is not quite trivial (a Postgres
array is not the same as a C array).  In the 7.1 code, there is a
deconstruct_array() function in src/backend/utils/adt/arrayfuncs.c
that will help.

> Also, how do I return an SQL NULL from a function?

In 7.0, you don't.  In 7.1, see src/backend/utils/fmgr/README.

            regards, tom lane

pgsql-general by date:

Previous
From: Kyle
Date:
Subject: making functions take arrays
Next
From: Nelio Alves Pereira Filho
Date:
Subject: System Tables