<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: after-white-space; "><DIV>Hi,</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>I migrated from mysql to postgres/postgis and update now all my map-queries. But I have a problem getting it working. I wonder if this is a major problem or some minor issue. The doc says :</DIV><DIV><B><BR class="khtml-block-placeholder"></B></DIV><DIV><B>"</B><FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 12.1px;"><B>Logical expressions allow you to build fairly complex tests based on one or more attributes and therefore are only available with shapefiles"</B></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 12.1px;"><BR class="khtml-block-placeholder"></SPAN></FONT></DIV><DIV><FONT class="Apple-style-span" face="Lucida Grande" size="3"><SPAN class="Apple-style-span" style="font-size: 12.1px;">So, i would almost presume that using EXPRESSIONS is not possible via postgis. But I can't imagine that this is true... In the moment it runs the query but with no result - meaning that it "ignores" the epression. I couldn't find anything similar in the archives either...</SPAN></FONT></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>LAYER</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>NAME bg_shape</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>CONNECTIONTYPE postgis</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>CONNECTION 'user=xxx password=xxx dbname=xxx' <SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN></DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>TYPE POLYGON</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>DATA 'the_geom FROM (SELECT countries.the_geom AS the_geom, regions_view.name AS name, countries.oid AS oid FROM countries, regions_view WHERE countries.geo_region = regions_view.id) AS foo USING UNIQUE oid USING srid=-1' </DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>CLASSITEM 'name' </DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>CLASS</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>NAME '' </DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>EXPRESSION ([name] ne 'Africa')</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>OUTLINECOLOR 230 230 230</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>COLOR 230 230 230</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>END</DIV><DIV><SPAN class="Apple-tab-span" style="white-space:pre"> </SPAN>END # LAYER</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Thanks for any help!</DIV><DIV><BR class="khtml-block-placeholder"></DIV><DIV>Stef</DIV><DIV><BR class="khtml-block-placeholder"></DIV></BODY></HTML>