Re: Bug with function returning composite types.

>>> Kyle Butt <kylebutt@gmail.com> 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_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_example.sql:32: NOTICE:  in bug_function
> psql:sql/bug_example.sql:32: NOTICE:  in bug_function
>  a | b | c | d | e | f | g | h | i | j
> ---+---+---+---+---+---+---+---+---+---
>  0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
> (1 row)

For completeness:

cir=# select * from bug_function();
NOTICE:  in bug_function
 a | b | c | d | e | f | g | h | i | j
---+---+---+---+---+---+---+---+---+---
 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
(1 row)

-Kevin