Thread: Questions regarding stored procedures

Questions regarding stored procedures

From
Todd Nemanich
Date:
Hello,
    I've gotten handed a MS SQL DB, and asked to port it to postgres. Most
of it has gone smooth, but the stored procedures are a real mess. The
original developer coded them up to use pass by reference variables,
rather than just return the results in a tuple. For the sake of not
having to change the application, I would like to try and do this in the
postgres version. Is this possible? THX.


Re: Questions regarding stored procedures

From
Doug McNaught
Date:
Todd Nemanich <todd@twopunks.org> writes:

> Hello,
>     I've gotten handed a MS SQL DB, and asked to port it to
> postgres. Most of it has gone smooth, but the stored procedures are a
> real mess. The original developer coded them up to use pass by
> reference variables, rather than just return the results in a
> tuple. For the sake of not having to change the application, I would
> like to try and do this in the postgres version. Is this possible? THX.

No.

-Doug