Reference: Text Functions

CedarDB supports a variety of functions for the text data type. This page currently only describes a subset of those. See SQL features for a full list of supported functions.

Pattern Matching

POSIX Regular Expressions

CedarDB allows to specify POSIX regular expressions within a pattern. The following functions allow to specify such a pattern.

regexp_like()

Arguments: (string, pattern [, flags ]))

The regexp_like() function compares a pattern to a string. It returns true if the pattern matches the string and false if it does not. If any input is null, the output is also null. Flags change the function’s semantics; for example, the i flag makes the pattern matching case-insensitive.

select regexp_like('The General Sherman tree is the largest tree in the world.', 'Tree.*Largest', 'i') as foo;

 foo 
-----
 t
(1 row)