[mapserver-users] PostGIS Data Query vs Expression

[Travis Kirstine]

What is the best practice for using selecting data with a where clause in
MapServer using PostGIS connection

i.e.

DATA "the_geom from (SELECT gid, the_geom FROM audience_table WHERE
audience = 'Farmers') as foo using unique gid using SRID=4326"

OR

DATA "the_geom from audience_table using SRID=4326"

with a class expression

CLASSITEM audience
....
EXPRESSION 'Farmer'

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20140207/3cc2e6cb/attachment.htm>