Functions that return composite types are called more times than expected.
Example script:
---
begin;
create table composite_types_test (
a integer,
b integer,
c integer,
d integer,
e integer,
f integer,
g integer,
h integer,
i integer,
j intege
>>> Kyle Butt wrote:
> select (bug_function()).*;
> psql:sql/bug_example.sql:32: NOTICE: in bug_function
> psql:sql/bug_example.sql:32: NOTICE: in bug_function
> psql:sql/bug_example.sql:32: NOTICE: in bug_function
> psql:sql/bug_example.sql:32: NOTICE: in bug_function
> psql:sql/bug_examp
On Mon, Mar 09, 2009 at 10:03:34AM -0500, Kevin Grittner wrote:
> >>> Kyle Butt wrote:
>
> > select (bug_function()).*;
>
> > psql:sql/bug_example.sql:32: NOTICE: in bug_function
> > psql:sql/bug_example.sql:32: NOTICE: in bug_function
> > psql:sql/bug_example.sql:32: NOTICE: in bug_functio