Insert Text Into Text

Jim_KnicelyJim_Knicely Administrator, Moderator, Employee, Registered User, VerticaExpert
edited January 31 in Vertica Tips

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:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/String/INSERT.htm

Have fun!

Sign In or Register to comment.