Luca Ferrari <fluca1978@xxxxxxxxxxx> writes: > I used the regexp_replace function to make a substitution over a table, but I > got a strange behaviour (please consider I'm not an expert of regex). The > idea is to remove the final part of a code, that could be TIF, ISTTIF, tif, > isttif, and at the same time consider only the records depending on the join > with another table. Now, the strange thing is that the first query updated > the most of records, but then 4 records are still there, and in fact > executing again the same update provides me another substitution. What could > be the reason? Maybe the original strings had more than one instance of 'TIF'? regards, tom lane
