Re: [GENERAL] Unable to match same value in field.

2016-03-12 Thread Peter J. Holzer
On 2016-03-10 11:09:00 +0200, Condor wrote: > I using postgresql 9.5.1 and I have problem to match value in one field. > Both tables are text: [...] > =# select imsi from list_cards_tbl where imsi = '28411123315'; > imsi > -- > (0 rows) > > No value, lets change to LIKE > > =# select ims

Re: [GENERAL] Unable to match same value in field.

2016-03-12 Thread Adrian Klaver
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 '28411123315' the only value y

Re: [GENERAL] Unable to match same value in field.

2016-03-11 Thread Adrian Klaver
On 03/11/2016 12:19 AM, Condor wrote: On 10-03-2016 15:37, Adrian Klaver wrote: On 03/10/2016 01:09 AM, Condor wrote: Hello, I using postgresql 9.5.1 and I have problem to match value in one field. Both tables are text: =# \d list_cards_tbl; Column | Type |

Re: [GENERAL] Unable to match same value in field.

2016-03-11 Thread Condor
On 10-03-2016 15:37, Adrian Klaver wrote: On 03/10/2016 01:09 AM, Condor wrote: Hello, I using postgresql 9.5.1 and I have problem to match value in one field. Both tables are text: =# \d list_cards_tbl; Column | Type | Modifiers ---+-+-

Re: [GENERAL] Unable to match same value in field.

2016-03-10 Thread Adrian Klaver
On 03/10/2016 01:09 AM, Condor wrote: Hello, I using postgresql 9.5.1 and I have problem to match value in one field. Both tables are text: =# \d list_cards_tbl; Column | Type | Modifiers ---+-+--

Re: [GENERAL] Unable to match same value in field.

2016-03-10 Thread Karsten Hilbert
On Thu, Mar 10, 2016 at 11:09:00AM +0200, Condor wrote: > Can some one point me what can be the problem with this value and how to > resolve it ? I think probably index problem but I reindex that table and > problem is not resolved For the fun of it try dropping all indexes on the table and rerun

[GENERAL] Unable to match same value in field.

2016-03-10 Thread Condor
Hello, I using postgresql 9.5.1 and I have problem to match value in one field. Both tables are text: =# \d list_cards_tbl; Column | Type | Modifiers ---+-+-- recid | integer | no