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

From Ken Winter
Subject Re: Confused about a function returning SETOF
Date
Msg-id 002d01c64df0$099dbca0$6706a8c0@kenxp
Whole thread Raw
In response to Re: Confused about a function returning SETOF  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Well, duh!  Thank you.  I could have stared at it for hours without seeing
it...

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Tuesday, March 21, 2006 11:12 PM
> To: ken@sunward.org
> Cc: PostgreSQL pg-general List
> Subject: Re: [GENERAL] Confused about a function returning SETOF
>
> "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: Janning Vygen
Date:
Subject: Re: Updating database structure
Next
From: Guy Fraser
Date:
Subject: Re: Advantages of PostgreSQL over MySQL 5.0