1 /* -*- sql -*- 

     2 

     3    mysql specific registered procedures, 

     4 

     5 */

     6 

     7 /* XXX limit_size version dealing with format as postgres version does.

     8    XXX mysql doesn't support overloading, each function should have a different name

     9        

    10    NOTE: fulltext renamed since it cause a mysql name conflict

    11  */

    12 

    13 CREATE FUNCTION text_limit_size(vfulltext TEXT, maxsize INT)

    14 RETURNS TEXT

    15 NO SQL

    16 BEGIN

    17     IF LENGTH(vfulltext) < maxsize THEN

    18        RETURN vfulltext;

    19     ELSE

    20        RETURN SUBSTRING(vfulltext from 1 for maxsize) || '...';

    21     END IF;

    22 END ;;