Hi All
Im trying to assign the value of a dynamic variable, to a variable.
How is this done in PostgresQL. Is this allowed in Postgres Procedural
Language
Here is my attempt.
variable1:= quote_ident('variable_'||quote_literal(year));
Where the variable is called
variable_2004
where name, represents the year
RESULT WANTED: variable1 gets assigned the value of variable_2004.
Any help is appreciated.Thanks
Kind Regards,
Shaun Clements