On Tuesday, February 13, 2018, armand pirvu <armand.pi...@gmail.com> 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.
