REPEAT

2026-02-03 08:48:37  Updated

Syntax

REPEAT(str, count)

Purpose

REPEAT() returns the string of str after repeating for count times. When count is less than or equal to 0, an empty string is returned. If any argument is NULL, the function returns NULL.

Examples

obclient> SELECT
     REPEAT('1', -1)
     REPEAT(null, null)
     REPEAT('Abc', 4)
     \G
*************************** 1. row ***************************
   REPEAT('1', -1):
REPEAT(null, null): NULL
  REPEAT('Abc', 4): AbcAbcAbcAbc
1 row in set

Contact Us