On 09/30/11 12:57 AM, J.V. wrote:
> I need to run a series of stored procedures, what is the best way to
> organize and run.
>
> Ideally would like something like Oracle PL/SQL where I can put all
> methods in one file and create a main() method
>
> then just : select main() to have them all run.
in function main, have
select function1();
select function2();
...
> Also is it possible to call a stored function or procedure from
> another stored proc/function?
see above.
note that postgres doesn't acctually have stored procedures, it only has
functions.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast