Re: [BUGS] BUG #5920: SQL function are probably "overoptimized"

2011-03-07 Thread Itagaki Takahiro
On Tue, Mar 8, 2011 at 12:49, Matyas Novak 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

[BUGS] BUG #5920: SQL function are probably "overoptimized"

2011-03-07 Thread Matyas Novak
The following bug has been logged online: Bug reference: 5920 Logged by: Matyas Novak Email address: lo...@centrum.cz PostgreSQL version: 9.0.1 Operating system: linux Description:SQL function are probably "overoptimized" Details: create table a(a integer); create o