Book Contents

Book Index

Next Topic

Home

REPEAT

REPEAT returns a VARCHAR value containing a specified string repeated a specified number of times.

Syntax

REPEAT ( string , repetitions )

Semantics

 

string

(CHAR or VARCHAR) is the string to repeat

repetitions

(INTEGER) is the number of times to repeat the string

Examples

=> SELECT REPEAT ('1234', 5);

repeat

----------------------

12341234123412341234

(1 row)