Function Category: String Functions

45 articles

regexp_substr() — PostgreSQL string function

regexp_substr(): extract substring that matches regexp. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

repeat() — PostgreSQL string function

repeat(): replicate string n times. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

replace() — PostgreSQL string function

replace(): replace all occurrences in string of old_substr with new_substr. PostgreSQL string functions — signature, volatility, version applicability and an…

right() — PostgreSQL string function

right(): extract the last n characters. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

rpad() — PostgreSQL string function

rpad(): right-pad string to length. PostgreSQL string functions — signature, volatility, version applicability and an illustrative example.

rtrim() — PostgreSQL string function

rtrim(): trim selected characters from right end of string. PostgreSQL string functions — signature, volatility, version applicability and an illustrative…