Re: improvise callbacks in plpgsql
От | Merlin Moncure |
---|---|
Тема | Re: improvise callbacks in plpgsql |
Дата | |
Msg-id | 6EE64EF3AB31D5448D0007DD34EEB3417DD767@Herge.rcsinc.local обсуждение исходный текст |
Ответ на | improvise callbacks in plpgsql ("Merlin Moncure" <merlin.moncure@rcsonline.com>) |
Ответы |
Re: improvise callbacks in plpgsql
|
Список | pgsql-performance |
> The body of callit() need be little more than OidFunctionCall1() > plus whatever error checking and security checking you want to > include. esp=# create table test(f text); CREATE TABLE esp=# create function test() returns void as $$ begin insert into test values ('called'); end; $$ language plpgsql; esp=# create or replace function test2() returns void as esp-# $$ esp$# declare esp$# r record; esp$# begin esp$# select into r 'abc'; esp$# perform callit('test()'::regprocedure, r); esp$# end; esp$# esp$# $$ language plpgsql; CREATE FUNCTION esp=# select test2(); esp=# select * from test; f -------- called (1 row) one word... w00t Merlin
В списке pgsql-performance по дате отправления: