Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f32F7wK98249 for ; Mon, 2 Apr 2001 11:07:58 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.11.3/8.11.3/Debian 8.11.2-1) id f32F7fU21956; Mon, 2 Apr 2001 09:07:41 -0600 Date: Mon, 2 Apr 2001 09:07:41 -0600 From: Roberto Mello To: Edipo Elder Fernandes de Melo Cc: pgsql-sql@postgresql.org Subject: Re: Calling functions inside a function: behavior Message-ID: <20010402090741.A21930@cc.usu.edu> References: <200104021150.f32BoqK60742@postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.15i In-Reply-To: <200104021150.f32BoqK60742@postgresql.org>; from edipoelder@ig.com.br on Mon, Apr 02, 2001 at 08:50:32AM -0300 X-Archive-Number: 200104/12 X-Sequence-Number: 2351 On Mon, Apr 02, 2001 at 08:50:32AM -0300, Edipo Elder Fernandes de Melo wrote: > > and, for my surprise, it take minutes to run. I read the documentation > and I didn't found any coment abou this behavior. Can anyone explain this? Cool, one more Brazilian in the list :) I don't see any difference between calling the functions with a select or a perform, except that with perform the return value is discarded. What version of PG are you running and what are those functions written in (PL/pgSQL, PL/Tcl, PL/Perl)? Can you post a snippet of the functions here? -Roberto -- +----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+ Roberto Mello - Computer Science, USU - http://www.brasileiro.net http://www.sdl.usu.edu - Space Dynamics Lab, Developer TOFU -> Text Oben Fullquote Unten