Re: call by reference vs call by value

I am trying to translate some Oracle PL/SQL code which has the following
signature:
* PROCEDURE dGetQuestionSetKeyOrder*
* (pweb_site_name_i IN
tx_web_site.web_site_name%TYPE,*
* p_sid_i IN varchar2, *
* pqs_table_i IN OUT NOCOPY
XPORTAL_QUESTION_SET_TABLE*
* )*
"NOCOPY" tells oracle that pqs_table_i is call by reference. I was
wondering if pgplsql has a similar mechanism. Apparently not. Thanks!

On Tue, Dec 8, 2015 at 11:15 AM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tue, Dec 8, 2015 at 12:07 PM, Michael Moore <michaeljmoore(at)gmail(dot)com>
> wrote:
>
>> How are variables in pg/psql functions passed? I'm sure this is
>> documented somewhere. I looked but no joy. A link would be great! TIA
>>
>
> ​I doubt its documented anywhere since the concept of "by reference" is
> not part of the language. The concept is also not part of SQL.
>
> If you want a better explanation you should provide some code for us to
> comment upon.
>
> David J.
>
>
>