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!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
