The REPEAT function returns the character string with a length equal to the number of repeated input character strings. The return value is a VARCHAR type. The maximum length of the characcter string is 33,554,432 and if it this length is exceeded, NULL will be returned. If one of the parameters is NULL, NULL will be returned.
REPEAT( string, count )
SELECT REPEAT('cubrid',3);
repeat('cubrid', 3)
======================
'cubridcubridcubrid'
SELECT REPEAT('cubrid',32000000);
repeat('cubrid', 32000000)
======================
NULL
SELECT REPEAT('cubrid',-1);
repeat('cubrid', -1)
======================
''
SELECT REPEAT('cubrid','a');
ERROR: Cannot coerce value of domain "character" to domain "integer".