Thread: Evaluate a variable

Hi,

Is there anyway to evaluate a variable in plpgsql, like eval on PHP?
Suppose the example:

my_var:=''some value!'';
a:=''my_var'';
b:=<eval!!> a;

I already tried b:=EXECUTE a; without luck!

Best regards,
Luís Sousa

Luís Sousa wrote:
> Hi,
> 
> Is there anyway to evaluate a variable in plpgsql, like eval on PHP?
> Suppose the example:
> 
> my_var:=''some value!'';
> a:=''my_var'';
> b:=<eval!!> a;
> 
> I already tried b:=EXECUTE a; without luck!

Maybe stashing a SELECT in front?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.