Re: Confused about a function returning SETOF

Well, duh! Thank you. I could have stared at it for hours without seeing
it...

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Tuesday, March 21, 2006 11:12 PM
> To: ken(at)sunward(dot)org
> Cc: PostgreSQL pg-general List
> Subject: Re: [GENERAL] Confused about a function returning SETOF
>
> "Ken Winter" <ken(at)sunward(dot)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