Re: stored procedures (packages)

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