"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
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