'Select INTO" in Execute (dynamic query )

["Dinesh Pandey" <dpandey@xxxxxxxx>]

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