Re: PL/SQL: function call like $1($2)

On Sun, Oct 08, 2006 at 05:49:11PM +0200, Jean-Gerard Pailloncy wrote:
> I try EXECUTE f || ' ( ' || p || ' );' INTO res
> But is does not work too.
> There is no function to convert double precision[] to text.

You could use the types' input and output functions or perhaps
array_to_string().

stmt := 'SELECT ' || quote_ident(f) || '(' || quote_literal(textin(array_out(p))) || ')';
EXECUTE stmt INTO res;

--
Michael Fuhr