Postgres Pro
Downloads
Home   >   mailing lists

Re: Bug with function returning composite types. - Mailing list pgsql-bugs

From Kevin Grittner
Subject Re: Bug with function returning composite types.
Date
Msg-id 49B4E976.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Bug with function returning composite types.  (Kyle Butt <kylebutt@gmail.com>)
Responses Re: Bug with function returning composite types.
List pgsql-bugs
Tree view 
>>> 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

pgsql-bugs by date:

Previous
From: Kyle Butt
Date:
Subject: Bug with function returning composite types.
Next
From: Kyle Butt
Date:
Subject: Re: Bug with function returning composite types.