Hello,
I found easy implementation of variadic functions. It's based on
adapation FuncnameGetCandidates. When I found variadic function, then
I should create accurate number of last arguments (diff between
pronargs and nargs). Variadic function can be signed via flag or via
some pseudotype. Flag is better - allows variadic arguments of any
type. In static languages (like SQL or PL/pgSQL) variadic variables
can ba accessed via array (variadic arguments can be only nonarray).
This isn't problem in C language, there are arguments available
directly.
Sample:
CREATE OR REPLACE FUNCTION Least(anyelement)
RETURNS anyelement AS $$
SELECT MIN($1[i])
FROM generate_series(1, array_upper($1,1)) g(i);
$$ LANGUAGE SQL IMMUTABLE VARIADIC.
This sample is really simple. The goal is support sophistic libraries
like JSON support: http://www.mysqludf.org/lib_mysqludf_json/index.php
Main change in FuncnameGetCandidates.
if (!OidIsValid(variadic_oid))
{
memcpy(newResult->args, procform->proargtypes.values,
pronargs * sizeof(Oid));
}
else
{
int j;
/* copy nonvariadic parameters */
memcpy(newResult->args, procform->proargtypes.values,
pronargs * sizeof(Oid));
/* set variadic parameters, !!!!!!!!!!! */
for (j = pronargs - 1; j < nargs; j++)
newResult->args[j] = variadic_oid;
}
I invite any ideas, notes
Regards
Pavel Stehule
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
