Left

-- Function: fnt_left(character varying, integer)

-- DROP FUNCTION fnt_left(character varying, integer);

CREATE OR REPLACE FUNCTION fnt_left(character varying, integer)
  RETURNS character varying AS
$BODY$
begin

    return substring($1, 1, $2);

end;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION fnt_left(character varying, integer)
  OWNER TO adempiere;