REPEAT

The REPEAT function repeats an input string expression as many times as specified.

Syntax

REPEAT('expr', n)

Arguments

Parameter

Description

'expr'

A TEXT expression

n

An INTEGER expression specifying the number of repetitions for the string expression

Return

  • Returns a TEXT string.

  • When n = 0, and empty string is returned.

  • When n < 0, an error is thrown.

Examples

For these example, consider the following table:

CREATE TABLE customer(customername TEXT);

INSERT INTO customer VALUES
 ('Alfreds Futterkiste'),
 ('Ana Trujillo Emparedados y helados'),
 ('Antonio Moreno Taquería'),
 ('Around the Horn');

Repeating Content of a Table Column

SELECT REPEAT(customername, 2) FROM customer;

repeat
--------------------------------------------------------------------
Alfreds FutterkisteAlfreds Futterkiste
Ana Trujillo Emparedados y heladosAna Trujillo Emparedados y helados
Antonio Moreno TaqueríaAntonio Moreno Taquería
Around the HornAround the Horn

Repeating a String

SELECT REPEAT('abc', 3);

repeat
---------
abcabcabc

Repeating a String 0 Times

SELECT REPEAT('abc', 0);

repeat
------

Repeating an Empty String

SELECT REPEAT('', 3);

repeat
------