left

Create a user-define function that trims row data from the 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 FUNCTION IF NOT EXISTS cycling.left (column TEXT,num int) 
   RETURNS NULL ON NULL INPUT 
   RETURNS text 
   LANGUAGE javascript AS 
   $$ column.substring(0,num) $$ ;