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 B3F843126BE for ; Tue, 10 Jun 2003 03:15:44 +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 18814-04 for ; Tue, 10 Jun 2003 00:15:34 -0300 (ADT) Received: from smtp.noos.fr (nan-smtp-02.noos.net [212.198.2.71]) by svr1.postgresql.org (Postfix) with ESMTP id 40DBE30FE85 for ; Mon, 9 Jun 2003 11:22:33 +0000 (GMT) Received: (qmail 4498225 invoked by uid 0); 9 Jun 2003 11:22:32 -0000 Received: from unknown (HELO gmendola) ([212.198.40.246]) (envelope-sender ) by 212.198.2.71 (qmail-ldap-1.03) with SMTP for ; 9 Jun 2003 11:22:32 -0000 Message-ID: <006401c32e79$68424580$10d4a8c0@mm.eutelsat.org> From: "Mendola Gaetano" To: "Mr Weinbach, Larry" , References: <20030606221435.44876.qmail@web12906.mail.yahoo.com> Subject: Re: Using a RETURN NEXT Date: Mon, 9 Jun 2003 13:22:25 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Archive-Number: 200306/67 X-Sequence-Number: 13825 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