Skip to content

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.

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information