Postgres Pro
Downloads
Home   >   mailing lists

Re: blank in query - cannot return results - Mailing list pgsql-general

From David G. Johnston
Subject Re: blank in query - cannot return results
Date
Msg-id CAKFQuwa6VAbnBR9+2zkrgkiJW=-O8k6CCYdEtMmXhjV8xGsXgw@mail.gmail.com
Whole thread Raw
In response to Re: blank in query - cannot return results  (Emi <emilu@encs.concordia.ca>)
List pgsql-general
Tree view
On Thu, Oct 8, 2015 at 3:54 PM, Emi <emilu@encs.concordia.ca> 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 match and are not getting one that you need to look at your data and figure out where you misunderstanding lies.​

​David J​

​P.S.​

​"
a percent sign (%) matches any sequence of zero or more characters
​"


​Removing the space and putting a "%" in in place simply means that the space was optional, and since it now matches, is not present in the values that appear in this query but not the one with an explicit space.

Note that there are different kinds of spaces...

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: postgres standby won't start
Next
From: droberts
Date:
Subject: Re: Best practices for aggregate table design