You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Trying to parse the following example gives the error missing expression at or near ";"
CREATE OR REPLACEFUNCTIONpublic.test_pl(s integer, e integer)
RETURNS TABLE(id INTEGER) AS $$
BEGIN
id := s;
LOOP
EXIT WHEN id>e;
RETURN NEXT;
id := id +1;
END LOOP;
END
$$
LANGUAGE plpgsql;
after debugging i discovered that plpgsql_curr_compile->out_param_varno is -1 in function make_return_next_stmt for this example , so the function continues execution in the block else with comment "Note that a well-formed expression is required here; anything else is a compile-time error"
The text was updated successfully, but these errors were encountered:
Trying to parse the following example gives the error
missing expression at or near ";"
after debugging i discovered that
plpgsql_curr_compile->out_param_varno
is -1 in function make_return_next_stmt for this example , so the function continues execution in the block else with comment "Note that a well-formed expression is required here; anything else is a compile-time error"The text was updated successfully, but these errors were encountered: