Alexaki Sofia wrote:
> thank you for your answer.
>
> Could you tell me how such a function is it called?
>
> Let's say that the function is test(text[])
> how can I call this function from a sql command, i.e., what
> will be teh value of the input parameters?
>
> select test(?????????)
>
See contrib/dblink in CVS HEAD, specifically dblink_build_sql_insert(),
dblink_build_sql_delete(), or dblink_build_sql_update(). These functions
accept text arrays (and int2vector) as input. In the README there are
usage examples.
HTH,
Joe