[GENERAL] 'Select INTO" in Execute (dynamic query )

[Dinesh Pandey]

Hi   What’s wrong with this code (ERROR:  syntax error at or near "INTO" at character 8)?   Problem: I want to put A1, A2 values in two variables vara, varb.   CREATE OR REPLACE FUNCTION test(text) RETURNS VARCHAR AS $$ Declare           vara    VARCHAR(10) :='';           varb    VARCHAR(10) :='';           result  VARCHAR(10) :='Result';           BEGIN                     EXECUTE(                    'Select INTO vara, varb A1, A2 from '|| $1           );           RETURN result||': '|| vara ||' '|| varb;   END; $$ LANGUAGE plpgsql;     Regards Dinesh Pandey