author | Sylvain Thénault <sylvain.thenault@logilab.fr> |
Wed, 05 May 2010 18:54:19 +0200 | |
branch | stable |
changeset 5485 | 4a033d7f1d93 |
parent 3928 | 2ced335a9b55 |
permissions | -rw-r--r-- |
/* -*- 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 ;;