Skip to content

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
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information