REPEAT

Replicates a string the specified number of times and concatenates the replicated values as a single string. The return value takes on the data type of the string argument. Return values for non-LONG data types and LONG data types can be up to 65000 and 32000000 bytes in length, respectively. If the length of string * count exceeds these limits, Vertica silently truncates the results.

Behavior type

Syntax

REPEAT ( 'string', count )

Arguments

string

The string to repeat, one of the following:

• CHAR

• VARCHAR

• BINARY

• VARBINARY

• LONG VARCHAR

• LONG VARBINARY

count

An integer expression that specifies how many times to repeat string.

Examples

The following example repeats vmart three times:

=> SELECT REPEAT ('vmart', 3);
     REPEAT
-----------------
 vmartvmartvmart
(1 row)