From: | "Ardian Xharra" <axharra(at)boxxo(dot)info> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com> |
Cc: | "postgreSQL postgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Why the data changes it's value by itself! |
Date: | 2006-11-16 19:15:26 |
Message-ID: | 178e01c709b3$929a9a30$0f01a8c0@Boxxo |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)archonet(dot)com>
To: "Ardian Xharra" <axharra(at)boxxo(dot)info>
Cc: "postgreSQL postgreSQL" <pgsql-general(at)postgresql(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | beer | 2006-11-16 19:24:43 | Accessing postgres in perl app using ssl authentication |
Previous Message | Tom Lane | 2006-11-16 18:53:37 | Re: Partial index |