<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
try this: <br>
<br>
<a class="moz-txt-link-freetext" href="https://stackoverflow.com/questions/4928054/postgresql-wildcard-like-for-any-of-a-list-of-words#4928415">https://stackoverflow.com/questions/4928054/postgresql-wildcard-like-for-any-of-a-list-of-words#4928415</a><br>
<br>
<pre class="lang-sql prettyprint prettyprinted" style=""><code><span class="pln">l<font size="+1">ower</font></span><font size="+1"><span class="pun">(</span><span class="pln">"Shape"</span><span class="pun">)</span><span class="pln"> similar </span><span class="kwd">to</span><span class="pln"> </span><span class="str">'(</span></font><font size="+1"><span class="str">rectangle</span></font><font size="+1"><span class="str">|triangle)' should do it.
Regards
walter
btw: why are you using ilike without wildchars?
</span></font><span class="pun">
</span></code></pre>
<div class="moz-cite-prefix">Am 28.07.2017 um 12:30 schrieb "Torben
Keßler":<br>
</div>
<blockquote type="cite"
cite="mid:trinity-abe37e79-22d2-45c3-83aa-0fa49a969352-1501237829882@3capp-webde-bs14">
<div style="font-family: Verdana;font-size: 12.0px;">
<div>Hello,</div>
<div> </div>
<div>is there a more elegant way for saying the following:</div>
<div> </div>
<div>"Shape" ILIKE 'rectangle' OR "Shape" ILIKE 'triangle' ?</div>
<div> </div>
<div>[obviously "Shape" ILIKE ('rectangle' OR 'triangle') does
not work]</div>
<div> </div>
<div>Many thanks!</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</body>
</html>