user-defined-function-left

CREATE OR REPLACE FUNCTION cycling.left (column text, num int)
  RETURNS NULL ON NULL INPUT
  RETURNS text
  LANGUAGE javascript AS $$ column.substring(0, num) $$;

DESCRIBE FUNCTION cycling.left;

DROP FUNCTION IF EXISTS cycling.left;

SELECT left(firstname, 1), lastname FROM cycling.cyclist_name;