From: Mr Weinbach, Larry <larryweinbach@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: Using a RETURN NEXT
Date: Tue, 10 Jun 2003 16:01:33 -0500 (CDT)
Message-ID: <20030610210133.70723.qmail@web12905.mail.yahoo.com> (raw)
In-Reply-To: <006401c32e79$68424580$10d4a8c0@mm.eutelsat.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: larryweinbach@yahoo.com
Subject: Re: Using a RETURN NEXT
In-Reply-To: <20030610210133.70723.qmail@web12905.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox