[mapserver-users] PostGIS query

[Julien Cigar]

On 01/31/2012 17:05, Carlos Ruiz wrote:
> Julien,

Hi Carlos,

>
> Have you tried with views ? When I need to map complex queries I build a
> view to just handle the where clauses.
>

I usually use a view, but in this case there are a lot of tables 
involved and I would like to avoid dozens of unnecessary JOIN

> Cheers from México
> IC Carlos Ruiz
>
> ------------------------------------------------------------------------
> *From:* Julien Cigar <jcigar at ulb.ac.be>
> *To:* "mapserver-users at lists.osgeo.org" <mapserver-users at lists.osgeo.org>
> *Sent:* Tuesday, January 31, 2012 6:38 AM
> *Subject:* [mapserver-users] PostGIS query
>
> Hello,
>
> Is there a way to (deeply) modify the SQL query in a PostGIS layer?
> I would like to add some JOIN, additional WHERE clauses, etc
> As I'm afraid that "Run-time Substitution" isn't flexible enough for
> this case ... is there any other possibility, other than mapscript?
>
> I guess there is no possibility to define variables, conditions, etc in
> a .map file .. ?
>
> Thanks,
> Julien
>
> -- No trees were killed in the creation of this message.
> However, many electrons were terribly inconvenienced.
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org <mailto:mapserver-users at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>


-- 
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: jcigar.vcf
Type: text/x-vcard
Size: 292 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120201/e42e3190/jcigar.vcf