Vertica Quick Tip: Repeating
Soniya Shah, Information Developer
March 13, 2018
This blog post 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 '1' || repeat('0', 100) AS "One Googolplex"; One Googolplex ------------------------------------------------------------------------------------------------------- 10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 (1 row) This function is also very useful if you plan on...