Re: [mapserver-users] Postgres/Postgis additonal variable request

2012-05-23 Thread Heiko Schroeter
Am Mittwoch, 23. Mai 2012, 14:58:02 schrieben Sie: thanks for the hint. I had to extend a bit (by probably complete misunderstanding and misinterpreting), but it works ! : DATA "the_geom from (select coords as the_geom, datum, HWFarbe[25] as farbe from %produkt%) as farbe using unique farbe u

Re: [mapserver-users] Postgres/Postgis additonal variable request

2012-05-23 Thread thomas bonfort
try this form: DATA "the_geom from (select id,coords as the_geom, *all_other_attributes_used_in_layer* from %farbe% join table2 on foo=bar where blabla) as foo using unique id using srid=xxx" On Wed, May 23, 2012 at 2:34 PM, Heiko Schroeter wrote: > Hello, > > i need to select data from an array

[mapserver-users] Postgres/Postgis additonal variable request

2012-05-23 Thread Heiko Schroeter
Hello, i need to select data from an array inside a table. I cannot get mapserver to create the correct select request statement. The problem i recognize is that the "unique" key is inserted in the Mapserver select request as " key from , ". Basically i need something like this: select