Re: Why the data changes it's value by itself!
От | Ardian Xharra |
---|---|
Тема | Re: Why the data changes it's value by itself! |
Дата | |
Msg-id | 178e01c709b3$929a9a30$0f01a8c0@Boxxo обсуждение исходный текст |
Ответ на | Why the data changes it's value by itself! ("Ardian Xharra" <axharra@boxxo.info>) |
Ответы |
Re: Why the data changes it's value by itself!
|
Список | pgsql-general |
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@archonet.com> To: "Ardian Xharra" <axharra@boxxo.info> Cc: "postgreSQL postgreSQL" <pgsql-general@postgresql.org> 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 > >
В списке pgsql-general по дате отправления: