Redshift Functions
String Functions
array_concat
Supported Signatures
function array_concat(super, ...) returns super
get_array_length
Supported Signatures
function get_array_length(super) returns bigint
json_array_length
Supported Signatures
function json_array_length(varchar) returns bigint
function json_array_length(varchar, boolean) returns bigint
regexp_replace
Supported Signatures
function regexp_replace(varchar, varchar) returns varchar
function regexp_replace(varchar, varchar, varchar) returns varchar
function regexp_replace(varchar, varchar, varchar, bigint) returns varchar
function regexp_replace(varchar, varchar, varchar, bigint, varchar) returns varchar
substr
Supported Signatures
function substr(varchar, bigint) returns varchar
function substr(varchar, bigint, bigint) returns varchar
substring
Supported Signatures
function substring(varchar, bigint) returns varchar
function substring(varchar, bigint, bigint) returns varchar