schemas/_regproc.mysql.sql
changeset 11057 0b59724cb3f2
parent 11052 058bb3dc685f
child 11058 23eb30449fe5
--- a/schemas/_regproc.mysql.sql	Mon Jan 04 18:40:30 2016 +0100
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,22 +0,0 @@
-/* -*- 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 TEXT
-NO SQL
-BEGIN
-    IF LENGTH(vfulltext) < maxsize THEN
-       RETURN vfulltext;
-    ELSE
-       RETURN SUBSTRING(vfulltext from 1 for maxsize) || '...';
-    END IF;
-END ;;