Postgres Pro
Downloads
Home   >   mailing lists

Re: call by reference vs call by value - Mailing list pgsql-sql

From Michael Moore
Subject Re: call by reference vs call by value
Date
Msg-id CACpWLjPtzUEqPybTwBG5gnnKz=mENbC_R8j9oE8Sy650Y3pG1A@mail.gmail.com
Whole thread Raw
In response to Re: call by reference vs call by value  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: call by reference vs call by value  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-sql
Tree view
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.g.johnston@gmail.com> wrote:
On Tue, Dec 8, 2015 at 12:07 PM, Michael Moore <michaeljmoore@gmail.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.



pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to manually load RETURNS SETOF RECORD?
Next
From: Pavel Stehule
Date:
Subject: Re: call by reference vs call by value