PL/SQL: function call like $1($2)
| От | Jean-Gerard Pailloncy |
|---|---|
| Тема | PL/SQL: function call like $1($2) |
| Дата | |
| Msg-id | AD0B2218-1C80-45AB-AF07-D151E68DE17E@rilk.com обсуждение исходный текст |
| Ответы |
Re: PL/SQL: function call like $1($2)
Re: PL/SQL: function call like $1($2) Re: PL/SQL: function call like $1($2) |
| Список | pgsql-general |
I want to create a function in PL/SQL as
CREATE OR REPLACE FUNCTION "f_do" (text, double precision[]) RETURNS
double precision AS '
DECLARE
f text := $1;
p double precision[] := $2;
res double precision;
BEGIN
SELECT f(p) into res;
RETURN res;
END;' LANGUAGE "plpgsql"
STABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
But it does not work.
I try EXECUTE f || ' ( ' || p || ' );' INTO res
But is does not work too.
There is no function to convert double precision[] to text.
Is it possible to do this without converting the array of double to
text ?
Pailloncy Jean-Gerard
В списке pgsql-general по дате отправления: