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

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Ingmar Brouns <swingi(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Re: volatile void returning function not executed as often as expected in sql function
Date: 2013-05-15 14:48:18
Message-ID: CAHyXU0yGXGwpUJBQJJek9WdyZS71OwonRX7yqksJeGtoo6Lqtw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, May 15, 2013 at 5:44 AM, Ingmar Brouns <swingi(at)gmail(dot)com> wrote:
> 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.

for non-trivial sql language processing functions I tend to return an
error code or string indicating success.

create or replace function foofunc2() returns int as
$func$
select foofunc(a) from foo;
select 0;
$func$ language sql;

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-05-15 14:50:41 Re: seeming overflow during avg() of intervals without errors/warnings
Previous Message Mike Christensen 2013-05-15 14:24:59 Re: dblink does not resolve DNS, but works with IP