Replacement method `anon.left` does not define a 2nd argument to pass along to pg_catalog.left
steps to reproduce:
select anon.left('foo', 2) limit 1;
ERROR: function anon.left(unknown, integer) does not exist
LINE 1: select anon.left('foo', 2) limit 1;
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
further introspection using \ef anon.left shows the definition as follows:
CREATE OR REPLACE FUNCTION anon."left"(text)
RETURNS text
LANGUAGE sql
PARALLEL SAFE
AS $function$ SELECT pg_catalog.left($1,$2) $function$
this is further reflected in the documentation, which shows anon.left as accepting only a single TEXT argument.