Re: call by reference vs call by value

2015-12-08 21:25 GMT+01:00 Michael Moore <michaeljmoore(at)gmail(dot)com>:

> 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!
>

It is totally different - NOCOPY hasn't any sense in Postgres

Pavel

>
>
> 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.
>>
>>
>>
>