Re: PL/PGSQL - dynamic variable names

On 06/28/2011 06:29 PM, Ben Carbery wrote:
> 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

Hm, "a" isn't a variable,it's the value of stuff[1]. Did you try
declaring a,b,c,d as the return type of the respective functions?