Insert Text Into Text: Quick Tip

Posted October 24, 2018 by Phil Molea, Sr. Information Developer, Vertica

Database Server Room
Jim Knicely authored this tip.

The built-in Vertica INSERT function injects a character string into a specified location in another character string.

Example: dbadmin=> SELECT insert('Vertica is AWESOME!', 12, 0, 'EXTREMELY '); insert ------------------------------- Vertica is EXTREMELY AWESOME! (1 row) Helpful Link:

Have fun!