Re: volatile void returning function not executed as often as expected in sql function

Поиск
Список
Период
Сортировка
От Ingmar Brouns
Тема Re: volatile void returning function not executed as often as expected in sql function
Дата
Msg-id CA+77E=YVGa7n6d4a17QGVg00j_QirCdAxRK-=o3EQxmVOuby-g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Re: volatile void returning function not executed as often as expected in sql function  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
When I send the mail, I saw it, the problem is that the function
should return setof void instead of void, then it works, sorry for
bothering.

pv=# --increase every a in foo by 1, but now in function
create or replace function foofunc2() returns setof void as
$func$
    select foofunc(a) from foo
$func$ language sql;


pv=# select foofunc2();
 foofunc2
----------



(3 rows)

pv=# select * from foo;
  a
-----
   1
  11
 101
(3 rows)


В списке pgsql-general по дате отправления:

Предыдущее
От: Ingmar Brouns
Дата:
Сообщение: volatile void returning function not executed as often as expected in sql function
Следующее
От: Hari Babu
Дата:
Сообщение: Re: pg_basebackup -R option in PG 9.3 beta