blank in query - cannot return results

From: Emi <emilu(at)encs(dot)concordia(dot)ca>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: blank in query - cannot return results
Date: 2015-10-08 19:51:29
Message-ID: 5616C941.8060907@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

PSQL terminal encoding: unicode (UTF-8). From both terminal and db,
values shows/and displayed as "Abc, test".

But " " space/blank in where section cannot return query result.

Can someone tell why may cause the issue please?

Thanks a lot!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Emi 2015-10-08 19:54:09 Re: blank in query - cannot return results
Previous Message Alvaro Herrera 2015-10-08 17:54:39 Re: dubious optimization of the function in SELECT INTO target list