For the column: date(varchar 8) '2000606' the
SELECT ascii(substring(date,4,1)) from jnlsale WHERE id_jnlsale=28384
gives: 22
SELECT ascii('6'); gives 54
For the column: amount(float 8) 1.20932764209866e-307 the
SELECT ascii(substring(amount,20,1)) from jnlsale WHERE id_jnlsale=28382
gives: 48
regards Ardian
----- Original Message -----
From: "Richard Huxton" <dev@xxxxxxxxxxxx>
To: "Ardian Xharra" <axharra@xxxxxxxxxx>
Cc: "postgreSQL postgreSQL" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, November 16, 2006 1:47 PM
Subject: Re: [GENERAL] Why the data changes it's value by itself!
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
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.6/535 - Release Date: 15/11/2006
