--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schemas/_regproc.mysql.sql	Fri Nov 27 15:43:45 2009 +0100
@@ -0,0 +1,22 @@
+/* -*- 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 ;;