PostgreSQL regexp_replace example

replace.sql

CREATE OR REPLACE FUNCTION isFoo(text) RETURNS BOOLEAN AS '
SELECT $1 ~* ''insert_regex_here'' AS RESULT
' LANGUAGE SQL;

UPDATE blocks 
SET content=(SELECT regexp_replace(content, 'insert_regex_here', 'insert_replace_text_here'));
;--WHERE isFoo(content);

SELECT *
FROM blocks 
WHERE isFoo(content);

The UPDATE should replace every occurrence of URLs like //../../../foo/whatever with a forward slash.

We'll have to execute that SQL query at least 4 times because it's actually replacing only the first occurrence of the regex match.