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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
