Re: cursors and function question

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tuesday, February 13, 2018, armand pirvu <armand.pirvu@xxxxxxxxx> wrote:
> CREATE OR REPLACE FUNCTION foofunc()
>    RETURNS text AS $$
>
> select foofunc();
>             foofunc
> -------------------------------
>  ("E1        ","CAT1      ",0)
>
> But I am looking to get
>
>             foofunc
> -------------------------------
>  ("E1        ","CAT1      ",0)
>  ("E1        ","CATs      ",0)

You need to specify SETOF

CREATE FUNCTION foofunc() RETURNS SETOF text AS

David J.