Re: BUG #5920: SQL function are probably "overoptimized"

From: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
To: Matyas Novak <logik(at)centrum(dot)cz>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5920: SQL function are probably "overoptimized"
Date: 2011-03-08 04:27:03
Message-ID: AANLkTi=dU=sEO3wUfw_ArsXC6wGv72KUvH9J4ZD=0aeu@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Mar 8, 2011 at 12:49, Matyas Novak <logik(at)centrum(dot)cz> wrote:
> Bug reference:      5920
>
> create or replace function f2 () returns void volatile language sql as
> $$
>  select f1(tmp) from (values ('aa'), ('bb')) _tmp(tmp);
> $$;
> select f2();
>
> As a result, only one row appears in table a, although two should be
> there...

It should be not a bug.
You probably need to define f2 as "returns SETOF void" function.

--
Itagaki Takahiro

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2011-03-08 04:45:55 Re: BUG #5919: released zipped files have problem
Previous Message Matyas Novak 2011-03-08 03:49:19 BUG #5920: SQL function are probably "overoptimized"