jianhe-fun/escape_regular_expression.sql

## escape_regular_expression.sql
/*
https://stackoverflow.com/questions/5144036/escape-function-for-regular-expression-or-like-patterns/45741630#45741630

escape regular expression.
*/

CREATE OR REPLACE FUNCTION public.f_regexp_escape(text)
 RETURNS text
 LANGUAGE sql
 IMMUTABLE PARALLEL SAFE STRICT
AS $function$
    select regexp_replace($1,'([!$()*+.:<=>?[\\\]^{|}-])','\\\1','g')
 $function$;
	/*
	https://stackoverflow.com/questions/5144036/escape-function-for-regular-expression-or-like-patterns/45741630#45741630

	escape regular expression.
	*/

	CREATE OR REPLACE FUNCTION public.f_regexp_escape(text)
	RETURNS text
	LANGUAGE sql
	IMMUTABLE PARALLEL SAFE STRICT
	AS $function$
	select regexp_replace($1,'([!$()*+.:<=>?[\\\]^{\|}-])','\\\1','g')
	$function$;