v.20.5Experimental Feature
Add hasSubstr function for subsequence search in arrays
Add's a hasSubstr function that allows for look for subsequences in arrays. Note: this function is likely to be renamed without further notice. #11071 (Ryad Zenine).Why it matters
ThehasSubstr function addresses the need to identify whether a given array contains a specific subsequence, enhancing array processing capabilities by enabling more precise pattern matching inside arrays.How to use it
Use thehasSubstr function by passing the target array and the subsequence array as arguments, for example:sql<br>SELECT hasSubstr(array, subsequence) FROM table<br>This function returns a Boolean indicating if the subsequence exists within the array.