Re: Using a RETURN NEXT

Thanks a lot Gaetano, Joe

Now, it is working.

--- Mendola Gaetano <mendola(at)bigfoot(dot)com> escribió: >
From: "Mr Weinbach, Larry" <larryweinbach(at)yahoo(dot)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