Re: Using a RETURN NEXT

Поиск
Список
Период
Сортировка
От Mendola Gaetano
Тема Re: Using a RETURN NEXT
Дата
Msg-id 006401c32e79$68424580$10d4a8c0@mm.eutelsat.org
обсуждение исходный текст
Ответ на Using a RETURN NEXT  ("Mr Weinbach, Larry" <larryweinbach@yahoo.com>)
Ответы Re: Using a RETURN NEXT  ("Mr Weinbach, Larry" <larryweinbach@yahoo.com>)
Список pgsql-sql
From: "Mr Weinbach, Larry" <larryweinbach@yahoo.com>

> But at execution time I am getting thi error :
> 
> WARNING:  Error occurred while executing PL/pgSQL
> function word_case
> WARNING:  line 5 at return next
> ERROR:  Set-valued function called in context that
> cannot accept a set
> 
> I also tried using my own type defined but I got the
> same error.
> 
> Any hint or idea will be appreciated ...

I guess that you are calling that function in this way:
#select word_case();

that function is a "table function" so you should use it like a table:

#select * from word_case();


Regards
Gaetano Mendola










В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: "Join" on delimeter aggregate query
Следующее
От: Eivind Kvedalen
Дата:
Сообщение: Re: "Join" on delimeter aggregate query