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