Re: Confused about a function returning SETOF

Поиск
Список
Период
Сортировка
От Ken Winter
Тема Re: Confused about a function returning SETOF
Дата
Msg-id 002d01c64df0$099dbca0$6706a8c0@kenxp
обсуждение исходный текст
Ответ на Re: Confused about a function returning SETOF  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Janning Vygen
Дата:
Сообщение: Re: Updating database structure
Следующее
От: Guy Fraser
Дата:
Сообщение: Re: Advantages of PostgreSQL over MySQL 5.0