[GENERAL] PL/PGSQL - dynamic variable names

[Ben Carbery]

Hi,

I am trying to EXECUTE .. INTO a variable that I want to be dynamically
named.

    stuff := '{a,b,c,d}';

    FOR i IN 1..4 LOOP
        thing := stuff[i];

        -- stuff_a, stuff_b etc are functions - substitution works here
        exec_string := 'SELECT stuff_' || thing || '(''' || arg1 || ''','''
|| arg2 || ''');';

        -- thing not substituted
        -- value of thing above is replaced on each iteration rather than
assigning result into variables a,b,c,d
        EXECUTE exec_string INTO thing;

    END LOOP;

The variable names always seems to be interpreted literally though. Is there
a way to make this work in PL/PGSQL?

Of course it would be nice if EXECUTE supported 'SELECT INTO' :)

cheers,

Ben