Ardian Xharra wrote:
No, sorry about the name of the table it's the same table.
Yes, the change is in live database during a select

OK, so it's definitely a data change. Can you get the numeric value of the character in question, and compare it to the original value
  SELECT ascii(substring(my_column,5,1)) WHERE ...;
  SELECT ascii('6');
You might want an index other than 5 of course.

What I'm wondering is whether this is a single-bit error that has occurred. If it is, I'd suspect hardware problems.

--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

Reply via email to