> > 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. >
in fact i'm trying to do the following thing: 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'
