<!DOCTYPE html><html><head><title></title><style type="text/css">p.MsoNormal,p.MsoNoSpacing{margin:0}</style></head><body><div>Hi,<br></div><div><br></div><div>Couldn't you just add a new field to the DATA clause and use that?<br></div><div><br></div><div><code>DATA "geom from (select pk, geom, size, (size * 2) as mycolor from sizes_of_thing) USING srid 3788 version 11g"
</code><br></div><div><code>CLASS
</code><br></div><div><code>MAXSCALEDENOM <span>5001</span> </code><br></div><div><code>STYLE
</code><br></div><div><code> COLOR [</code>mycolor<code>]</code><br></div><div><br></div><div>Or maybe this is a cut-down example.<br></div><div><br></div><div><code>Seth</code><br></div><div><code></code><br></div><div id="sig62266145"><div class="signature">--<br></div><div class="signature">web:<a href="https://geographika.net">https://geographika.net</a><br></div><div class="signature">twitter: @geographika<br></div></div><div><br></div><div><br></div><div>On Thu, Jun 16, 2022, at 11:04 AM, Andi p3 Domi wrote:<br></div><blockquote type="cite" id="qt" style=""><div dir="ltr"><div class="qt-gmail_quote"><div dir="ltr"><div style="font-size:small;"><div><p>I am trying to port my code from MapServer 5 (Oracle) to MapServer 7 (PostgreSQL),
but I am encountering an issue when trying to apply arithmetic expressions in the style class.
So previously in MapServer 5 I would have something like:<br></p><pre><code>DATA "geom from (select pk, geom, size from sizes_of_thing) USING srid 3788 version 11g"
CLASS
MAXSCALEDENOM <span>5001</span>
STYLE
COLOR [size<span>*</span><span>2</span>]
</code><br></pre><p>Which worked perfectly fine:
But if I convert it to MapServer 7 and PostgreSQL like:<br></p><pre><code>DATA "geom from (select pk, geom, size from sizes_of_thing sot) USING unique pk USING srid=3788"
CLASS
STYLE
COLOR [size<span>*</span><span>2</span>]
</code><br></pre><p>Throws an error such as:<br></p><pre><code>msPostGISLayerWhichShapes(): Error (ERROR: <span>column</span> "size*2" does <span>not</span> exist
</code><br></pre><p>By any chance are these expressions not supported anymore in MapServer 7/PostGIS or am I doing something wrong?<br></p><p>What I have tried so far is to write something like<br></p><pre><code>SIZE [size]<span>*</span><span>2</span>
SIZE ([size]<span>*</span><span>2</span>)
</code><br></pre><p>create an expression like:<br></p><pre><code>EXPRESSION ("size2" "[size]*2")
</code><br></pre><p>And use it in something like:<br></p><pre><code>SIZE [size2]
</code><br></pre><p>create a validation variable such as:<br></p><pre><code>VALIDATION
"size2" <span>'[size]*2'</span>
</code><br></pre><p>and then<br></p><pre><code>SIZE [size2]
</code><br></pre><p>But it seems like none of them work.<br></p></div></div></div></div></div><div>_______________________________________________<br></div><div>MapServer-users mailing list<br></div><div><a href="mailto:MapServer-users@lists.osgeo.org">MapServer-users@lists.osgeo.org</a><br></div><div><a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br></div><div><br></div></blockquote><div><br></div></body></html>