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
Attempting to parse a function such as the following, which in PostgreSQL works fine, currently fails with ParserError("Expected: ), found: INT")
CREATE OR REPLACEFUNCTIONcheck_values_different(int1 INT, int2 INT) RETURNS BOOLEANAS $$
BEGIN
IF int1 <> int2 THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;
$$ LANGUAGE plpgsql;
Surprisingly enough, the following instead works:
CREATE OR REPLACEFUNCTIONcheck_strings_different(str1 VARCHAR, str2 VARCHAR) RETURNS BOOLEANAS $$
BEGIN
IF str1 <> str2 THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;
$$ LANGUAGE plpgsql;
And even more weird, the following works, so it must be something regarding the name of the attribute int1 and int2 colliding with a type:
CREATE OR REPLACEFUNCTIONcheck_values_different(a INT, b INT) RETURNS BOOLEANAS $$
BEGIN
IF a <> b THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;
$$ LANGUAGE plpgsql;
I will try to fix this error in a PR soon.
The text was updated successfully, but these errors were encountered:
Attempting to parse a function such as the following, which in PostgreSQL works fine, currently fails with
ParserError("Expected: ), found: INT")
Surprisingly enough, the following instead works:
And even more weird, the following works, so it must be something regarding the name of the attribute
int1
andint2
colliding with a type:I will try to fix this error in a PR soon.
The text was updated successfully, but these errors were encountered: