Luca Ferrari <[EMAIL PROTECTED]> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
