I am currently writing a function that works with an array of rows. I need to write a value to a particular column of a particular row in the array. The following code should encapsulate the problem I'm having.
drop type if exists test_type; create type test_type as ( some_int int ); create or replace function test() returns void as $$ declare x test_type; y test_type; begin x = row(1); y = row(1); /* DOESN'T WORK */ /* ERROR: syntax error at or near "." */ /* x.some_int = 2; */ /* HOWEVER, THIS WORKS */ y = x; y.some_int = 2; x = y; raise notice '%', x.some_int; end; $$ language plpgsql;
As you can see, referencing
x.some_int is perfectly legal in most contexts but not for assignment. The workaround accomplishes the goal; however, it involves two additional copies via the assignment operator. Is there any explanation for why this is an error or how to work around it and accomplish this task without creating extra row copies?