Repeating

[Deleted User] · March 2018

This tip was authored by Jim Knicely.

The Vertica REPEAT function replicates a string the specified number of times, and concatenates the replicated values as a single string.

Examples:

dbadmin=> SELECT repeat('TesT', 5);
        repeat
----------------------
TesTTesTTesTTesTTesT
(1 row)

dbadmin=> SELECT '1' || repeat('0', 100) AS "One Googolplex";
                                            One Googolplex
-------------------------------------------------------------------------------------------------------
10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
(1 row)

This function is also very useful if you plan on telling the old “Pete and Repete are on a boat” joke:

dbadmin=> SELECT repeat('Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.' || CHR(10), 10);
repeat
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
Pete and Repete are in a boat. Pete jumps out. Who is left in the boat? Repete.
(1 row)

Have Fun!

We're Moving!

Create My New Community Account Now

Repeating