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

2005-04-18 Thread Tom Lane
"Dinesh Pandey" <[EMAIL PROTECTED]> writes: > What's wrong with this code (ERROR: syntax error at or near "INTO" at > character 8)? You can't use plpgsql's SELECT INTO in an EXECUTE'd command, because SELECT INTO means something entirely different to the main SQL engine. The usual workaround is

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

2005-04-18 Thread 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