X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 055C730EB3F for ; Tue, 10 Jun 2003 21:01:46 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 42684-06 for ; Tue, 10 Jun 2003 18:01:35 -0300 (ADT) Received: from web12905.mail.yahoo.com (web12905.mail.yahoo.com [216.136.174.72]) by svr1.postgresql.org (Postfix) with SMTP id 28DB230EB2E for ; Tue, 10 Jun 2003 18:01:34 -0300 (ADT) Message-ID: <20030610210133.70723.qmail@web12905.mail.yahoo.com> Received: from [200.38.247.126] by web12905.mail.yahoo.com via HTTP; Tue, 10 Jun 2003 16:01:33 CDT Date: Tue, 10 Jun 2003 16:01:33 -0500 (CDT) From: "=?iso-8859-1?q?Mr=20Weinbach,=20Larry?=" Subject: Re: Using a RETURN NEXT To: pgsql-sql@postgresql.org In-Reply-To: <006401c32e79$68424580$10d4a8c0@mm.eutelsat.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200306/93 X-Sequence-Number: 13851 Thanks a lot Gaetano, Joe Now, it is working. --- Mendola Gaetano escribió: > From: "Mr Weinbach, Larry" > > > 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