How does postgresql internally pass row type variables to procedures?

Question

I have table "Table1" and SQL procedure "testProc" which accepts argument of type "Table1". When this procedure gets invoked like this:

select testProc(t.*) from Table1 t;

is PostgreSQL internally using pointers for passing that argument? Or is it copied in memory for each row?

Thanks!

Chris Travers · Accepted Answer · 2013-03-14 04:07:47Z

1

There are two distinct cases here, one must involve a copy, and the second must involve pointers.

In the case you are mentioning a copy is made. You can test this like so:

create function test_test(inout test test) returns test as 
$$
begin
   $1.test := $1.test + 1;
   return;
end;
$$ language plpgsql;

select (test_test(t)).test, (test_test(t)).test from test t;

where test.test is an integer. The numbers will be the same.

The second is in triggers, where modifying NEW will be passed to the next trigger. These must be passed by reference.

answered Mar 14, 2013 at 4:07

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How does postgresql internally pass row type variables to procedures?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related