From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | emilu(at)encs(dot)concordia(dot)ca, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: blank in query - cannot return results |
Date: | 2015-10-08 20:03:41 |
Message-ID: | 5616CC1D.9050901@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-10-08 20:18:09 | Re: postgres standby won't start |
Previous Message | Emi | 2015-10-08 19:54:09 | Re: blank in query - cannot return results |