jianhe-fun · April 4, 2023 06:31
diff --git a/escape_regular_expression.sql b/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$;