On Thu, Oct 8, 2015 at 3:54 PM, Emi wrote:
> But run:
>> select * from table_name where col1 ilike '%Abc,%test%'; -- remove blank
>>
>> Result is returned.
>>
>
It works.
WITH vals (v) AS ( VALUES ('Abc, test'::text) )
SELECT *
FROM vals
WHERE v ILIKE '%Abc, test%'
If you are expecting a ma
On 10/08/2015 12:51 PM, Emi wrote:
Hello,
PostgreSQL 8.3.18 on x86_64-linux-gnu, query:
select * from table_name where col1 ='Abc, test';
select * from table_name where col1 ilike '%Abc, test%';
NO result returned.
Well without an indication of what the value in col1 is this is not
goi
Hello,
PostgreSQL 8.3.18 on x86_64-linux-gnu, query:
select * from table_name where col1 ='Abc, test';
select * from table_name where col1 ilike '%Abc, test%';
NO result returned.
But run:
select * from table_name where col1 ilike '%Abc,%test%'; -- remove
blank
Result is returned.
Hello,
PostgreSQL 8.3.18 on x86_64-linux-gnu, query:
select * from table_name where col1 ='Abc, test';
select * from table_name where col1 ilike '%Abc, test%';
NO result returned.
But run:
select * from table_name where col1 ilike '%Abc,%test%'; -- remove blank
Result is returned.
