/* -*- sql -*- mysql specific registered procedures, *//* XXX limit_size version dealing with format as postgres version does. XXX mysql doesn't support overloading, each function should have a different name NOTE: fulltext renamed since it cause a mysql name conflict */CREATE FUNCTION text_limit_size(vfulltext TEXT, maxsize INT)RETURNS TEXTNO SQLBEGIN IF LENGTH(vfulltext) < maxsize THEN RETURN vfulltext; ELSE RETURN SUBSTRING(vfulltext from 1 for maxsize) || '...'; END IF;END ;;