left

Create a user-define function that trims row data from the left. Requires that both enable_user_defined_functions and enable_scripted_user_defined_functions are enabled.

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