Re: call by reference vs call by value

Поиск
Список
Период
Сортировка
От Michael Moore
Тема Re: call by reference vs call by value
Дата
Msg-id CACpWLjPtzUEqPybTwBG5gnnKz=mENbC_R8j9oE8Sy650Y3pG1A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: call by reference vs call by value  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: call by reference vs call by value  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-sql
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to manually load RETURNS SETOF RECORD?
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: call by reference vs call by value