Received: from smtp-3.ig.com.br (smtp-3.ig.com.br [200.225.157.62] (may be forged)) by postgresql.org (8.11.3/8.11.1) with SMTP id f32BoqK60742 for ; Mon, 2 Apr 2001 07:50:52 -0400 (EDT) (envelope-from edipoelder@ig.com.br) Message-Id: <200104021150.f32BoqK60742@postgresql.org> Received: (qmail 2961 invoked from network); 2 Apr 2001 11:50:32 -0000 Received: from webmail-9.ig.com.br (HELO localhost) (200.225.157.214) by smtp-3.ig.com.br with SMTP; 2 Apr 2001 11:50:32 -0000 Date: Mon, 2 Apr 2001 08:50:32 -0300 To: pgsql-sql@postgresql.org From: Edipo Elder Fernandes de Melo Cc: X-Originating-IP: [200.17.143.31]200.19.161.175 X-Mailer: InMail by Insite - www.insite.com.br X-user: edipoelder@ig.com.br Subject: Calling functions inside a function: behavior X-Archive-Number: 200104/8 X-Sequence-Number: 2347 Hi all, I wrote a function that call another functions, like this: FUNCTION (...) AS '(...)BEGIN PERFORM FUNCTION1(); PERFORM FUNCTION2(); (...) END;' LANGUAGE 'PLPGSQL'; The problem is that takes a long time to execute (I stoped after three days executing). To see who taking more time to execute, I modified each one to return the time of its execution. Then, a made a scrip like: SELECT TIMESTAMP 'NOW'; SELECT FUNCTION1(); SELECT FUNCTION2(); (...) SELECT TIMESTAMP 'NOW'; 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? Thank you, Edipo Elder [edipoelder@ig.com.br] _________________________________________________________ Oi! Você quer um iG-mail gratuito? Então clique aqui: http://www.ig.com.br/paginas/assineigmail.html