Re: Confused about a function returning SETOF - Mailing list pgsql-general

From Tom Lane
Subject Re: Confused about a function returning SETOF
Date
Msg-id 9858.1143000732@sss.pgh.pa.us
Whole thread Raw
In response to Confused about a function returning SETOF  ("Ken Winter" <ken@sunward.org>)
Responses Re: Confused about a function returning SETOF
List pgsql-general
"Ken Winter" <ken@sunward.org> writes:
> select lov_personinorganization_role_status('Student','Applicant');
> ERROR:  set-valued function called in context that cannot accept a set

You need to write
  select * from lov_personinorganization_role_status('Student','Applicant');

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How I can get the real data type result instead of
Next
From: "Qingqing Zhou"
Date:
Subject: Re: PANIC: heap_update_redo: no block