Re: Using a RETURN NEXT

Поиск
Список
Период
Сортировка
От Mr Weinbach, Larry
Тема Re: Using a RETURN NEXT
Дата
Msg-id 20030610210133.70723.qmail@web12905.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Using a RETURN NEXT  ("Mendola Gaetano" <mendola@bigfoot.com>)
Список pgsql-sql
Thanks a lot Gaetano, Joe

Now, it is working.
--- Mendola Gaetano <mendola@bigfoot.com> escribió: >
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
> 
> 
> 
> 
> 
> 
> 
>  

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com


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

Предыдущее
От: Guy Fraser
Дата:
Сообщение: Re: Creating Views with Column Names based on Distinct
Следующее
От: David Pradier
Дата:
Сообщение: How to make a IN without a table... ?