Re: Need help with INOUT mis-understanding

From: "Troy" <troy(at)hendrix(dot)biz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help with INOUT mis-understanding
Date: 2005-10-26 15:21:25
Message-ID: 1130340085.521984.75840@g47g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Probably not, if the way you seem to expect it to work is like Oracle.
> An INOUT parameter isn't some sort of modifiable by-reference variable,
> it's just a shorthand for declaring an IN parameter and an OUT
> parameter.
>

Thanks for the response.

That makes a lot of sense but I guess I was wishing to make it work in
porting all the oracle pl/sql.

If I have a function with 3 INOUTs and I get a return of (30,20,1) how
should I structure it so I can read only the "1" from another function
call? Should I be doing SETOF? I just haven't figured how to parse
results within functions.. any suggestions for me?

Thank you
Troy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2005-10-26 15:27:46 Why database is corrupted after re-booting
Previous Message Tom Lane 2005-10-26 15:15:39 Re: Need help with INOUT mis-understanding