#pattern-matching

#pattern-matching

Structural pattern matching is a powerful control flow construct invented decades ago that's traditionally used by compiled languages, especially within the functional programming paradigm.

Pattern matching using LIKE and ILIKE allows us to determine if a given piece of text matches a particular pattern; these operators are fundamental in SQL for text searches.