replacement method anon.right is implemented incorrectly
steps to reproduce:
select anon.right('foo', 2) limit 1;
output:
ERROR: function pg_catalog.md5(text, integer) does not exist at character 9
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT pg_catalog.md5($1,$2)
checking the implementation using \ef anon.right
shows the following:
CREATE OR REPLACE FUNCTION anon."right"(text, integer)
RETURNS text
LANGUAGE sql
PARALLEL SAFE
AS $function$ SELECT pg_catalog.md5($1,$2) $function$
expected behavior is that anon.right should not use md5 as part of the implementation.
Edited by Austin Putman