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