[SQL] Calling inner functions vs. Begin-End blocs

2011-06-15 Thread Charles N. Charotti
Hi Everybody ! I'm just wondering what is really better in terms of performance ... I have a large function that makes many things, and I must control the exception of some parts of the code ... whats better in terms of performance ... to catch exceptions in several inner "Begin-End" blocs in

[SQL] PLpgSQL variables persistance between several functions calls

2011-05-02 Thread Charles N. Charotti
Hello everybody ! I want to know if I could share PLpgSQL variables between different functions and within different calls just using memory (not tables or other methods). If it is really possible ? Thanks in advance, Chuck