Re: blank in query - cannot return results

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
going anywhere.

My suspicion is you are looking for regex:

http://www.postgresql.org/docs/9.4/interactive/functions-matching.html#FUNCTIONS-POSIX-REGEXP

>
>
> 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!
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com