Re: regexp_replace in two times?

Luca Ferrari <fluca1978@infinito.it> 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