gentoobrowse-api/service/sql/maintenance/updatesMoveFilelist.sql


1
2
3
4
5
6

UPDATE filelist SET
	pathparts[3] = ?,
	pathparts[4] = REGEXP_REPLACE(pathparts[4], CONCAT('^', REPLACE(?, '+', '\+'), '(-[0-9])'), CONCAT(?::text, '\1'))
WHERE pathparts[3] = ?
AND pathparts[4] ~ CONCAT('^', replace(?, '+', '\+'), '-[0-9]')
AND filetypeId = 1