Pull: Difference between revisions
From Data Islands
WikiSysopdi (talk | contribs) (LIKE operator Replaced with ILIKE) |
WikiSysopdi (talk | contribs) (LIKE operator description.) |
||
| Line 6: | Line 6: | ||
Please note: | Please note: | ||
If we use LIKE operator | If we wants to use query select statement with LIKE operator as case insenstive then we need to use ILIKE instead of LIKE operator as PostgreSQL understand ILIKE to make where condition as case in-sensitive, so for example, we need to give the payload as: | ||
"{\"Query\": \"select * from customers where \\\"CompanyName\\\" | "{\"Query\": \"select * from customers where \\\"CompanyName\\\" ILIKE '%Ana%'\"}" | ||
Revision as of 06:21, 21 September 2022
Syntax
pull island destinationname "<whereclause>"
Please note:
If we wants to use query select statement with LIKE operator as case insenstive then we need to use ILIKE instead of LIKE operator as PostgreSQL understand ILIKE to make where condition as case in-sensitive, so for example, we need to give the payload as:
"{\"Query\": \"select * from customers where \\\"CompanyName\\\" ILIKE '%Ana%'\"}"
