Vertica Analytics Platform Version 9.2.x Documentation

INSERT

Inserts a character string into a specified location in another character string.

Syntax

INSERT( 'string1', n, m, 'string2' )

Behavior Type

Immutable

Parameters

string1

(VARCHAR) Is the string in which to insert the new string.

n

A character of type INTEGER that represents the starting point for the insertion within string1. You specify the number of characters from the first character in string1 as the starting point for the insertion. For example, to insert characters before "c", in the string "abcdef," enter 3.

m

A character of type INTEGER that represents the number of characters in string1 (if any) that should be replaced by the insertion. For example,if you want the insertion to replace the letters "cd" in the string "abcdef, " enter 2.

string2

(VARCHAR) Is the string to be inserted.

Example

The following example changes the string Warehouse to Storehouse using the INSERT function:

=> SELECT INSERT ('Warehouse',1,3,'Stor');
   INSERT
------------
 Storehouse
(1 row)