Re: Calling functions inside a function: behavior

From: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
To: Edipo Elder Fernandes de Melo <edipoelder(at)ig(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Calling functions inside a function: behavior
Date: 2001-04-02 15:07:41
Message-ID: 20010402090741.A21930@cc.usu.edu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message comp 2001-04-02 15:09:34 Sql error
Previous Message Bruce Momjian 2001-04-02 15:07:09 Re: Re: [SQL] Re: pg_dump potential bug -UNIQUE INDEX on PG_SHADOW Dont!! HELP