REPEAT Function

Description

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.

Syntax

REPEAT( string, count )

Example

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".