Hi,
i have a character varying variable and i concatenate with some other variable, using the '||' operator.
the result of this concatenation should be the name of a column in my table.
however i don't know how to tell that this new concatenated string is a column name.
how to do it ?
thanks.
select id, theme_ || $1 from themes;
and based on the parameter my stored procedure has received, it should create something like that:
select id, theme_eng from themes;
if $1 = 'eng'