I´ve solved the problem of of 'one to many'; really, is a mapserver issue not a pmapper´s one:
-First, add a new field 'id' type 'serial' to the table2, which is the principal key of table2 (that is the point, which you have to specify in mapfile...) -Second: create the view 'myview' one to many in Postgis (table1-->table2). -Third: In Data object for the layer, set: DATA 'the_geom FROM (select the_geom, id, othersfields FROM myview) AS myview_id USING UNIQUE id' #this identifies the relation one to many. 2008/7/7 Gabriel Messner <[EMAIL PROTECTED]>: > > > 2008/6/25 Armin Burger <[EMAIL PROTECTED]>: > > On 25/06/2008 18:03, pag66 wrote: >> > Hello everyone i wanto to join a posgtres table to a posdtgis table >> using a >> > one to many relation, i mean one geographic point to many register in >> the >> > other table how i could make this posible ? >> > Thanks a lot >> > >> >> you can either create a DB view or define the join in the DATA tag. See >> the FAQ or PostGIS docs for more info. >> >> armin >> >> ------------------------------------------------------------------------- >> Check out the new SourceForge.net Marketplace. >> It's the best place to buy or sell services for >> just about anything Open Source. >> http://sourceforge.net/services/buy/index.php >> _______________________________________________ >> pmapper-users mailing list >> pmapper-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/pmapper-users >> > > ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
