Re: Unable to match same value in field. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Unable to match same value in field.
Date
Msg-id 56E46372.7090605@aklaver.com
Whole thread Raw
In response to Unable to match same value in field.  (Condor <condor@stz-bg.com>)
List pgsql-general
On 03/12/2016 08:11 AM, Condor wrote:
Ccing list

>>>> On 03/10/2016 01:09 AM, Condor wrote:

>>
>>> Process that populate them isnt the same but data is coming from
>>> database not from user input filed.
>>>
>>> Any ideas ?
>>
>> Not at the moment, but some unanswered questions:
>>
>> Is '284110000123315' the only value you are having issues with?
>
> Yes, I now make some tests, it's seems that is the only value that make
> troubles.
>
>>
>> What happens if you populate the field in list_cards_tbl with
>> the data from list_newcards_tbl?
>>
>
> Everything is work. I update value with '284110000123315' manual (I just
> select value with like and update it) and then rerun query and server
> now found that data.
> Yes, I can do that in first moment but was very strange for me why after
> rebuild value still cant be find when md5 and bit_length prove that is
> the same string.

I do not know, that is why I Cced list, maybe someone else has an idea.

>
> Any way, problem solved.
>
> HS
>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: index problems (again)
Next
From: Karsten Hilbert
Date:
Subject: Q: extract database name from directory dump