PostgreSQL plpgsql - variable column names

Question

I am creating a trigger, which uses dynamic names for columns

NEW.name:=2222; -- works fine !

but

dynamic_column:='name';
EXECUTE '$1.'||dynamic_column||':=2222 ' USING NEW; -- raises error

gives an error:

ERROR: syntax error at or near "$1" LINE 1: $1.name:=2222

Answer 1

I found info here: Assign to NEW by key in a Postgres trigger

If we enable the module hstore by:

CREATE EXTENSION hstore;

We can do this:

dynamic_column:='name';    
temp_sql_string:='"'||dynamic_column||'"=>"2222"';
NEW := NEW #= temp_sql_string::hstore;

And the RECORD NEW.name now is set to the value 2222.

Thank you tough for making an effort to find a solution @Laurenz Albe