Function call in postgresql returns no resultset

Question

I have a postgresql function like

create or replace function getalltypes(name character varying(100))
returns  setof docs as $BODY$ 

begin
perform c.contenttypename from conttype c;

end;
$BODY$  LANGUAGE PLPGSQL;

docs is a type I have created

create type docs as (contenttypename character varying(100))

on

select getalltypes('')

No result is getting displayed. Can anyone please help?

you probably want to change perform c.contenttypename from conttype c; to return query c.contenttypename from conttype c; ?.. — Vao Tsun
– Vao Tsun, Commented Nov 16, 2016 at 11:18
@VaoTsun - 'return query c.contenttypename from conttype c;' is showing an error at 'c'. I changed to 'return query select c.contenttypename from conttype c;' Then it worked. Thank you — Ajoe
– Ajoe, Commented Nov 16, 2016 at 12:25

Vao Tsun · Accepted Answer · 2016-11-16 13:22:32Z

1

You don't have any return statement. This is why you see no result. PERFORM is used to evaluate the query and DISCARD the result This is why you should change perform c.contenttypename from conttype c; to smth like return query select c.contenttypename from conttype c;.

answered Nov 16, 2016 at 13:22

Vao Tsun

52.5k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Function call in postgresql returns no resultset

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related