Sory for forgetting the mapfile ... Here it is!
MAP
NAME "Ma carte"
FONTSET "C:\Program Files\FWTools1.0.0\Fonts\fonts.txt"
SIZE 15000 9550
EXTENT 2.666432 48.798993 2.750456 48.852482
IMAGETYPE svg
LAYER #road layer
CONNECTIONTYPE postgis
TYPE LINE
NAME "routes"
CONNECTION "user=a password=a dbname=bussy host=localhost"
DATA "wkb_geometry FROM bussy_saint_georges_routier_total
using unique id"
STATUS ON
CLASS
COLOR 0 0 255
END
END
LAYER #label layer
CONNECTIONTYPE postgis
TYPE ANNOTATION
NAME "labels_local"
CONNECTION "user=a password=a dbname=bussy host=localhost"
DATA "wkb_geometry FROM (SELECT Collect(wkb_geometry) as
wkb_geometry, nom, code_insee_l, min(id) as id FROM
bussy_saint_georges_routier_local WHERE nom <> '' GROUP BY nom,
code_insee_l) as test using unique id"
STATUS ON
LABELITEM 'NOM'
CLASS
STYLE
COLOR -1 -1 -1 #the layer must be transparent
END
LABEL
COLOR 100 100 100 #only features are drawn
TYPE truetype
FONT arial
SIZE 10
POSITION cc
ANGLE follow
FORCE true
END #label
END #class
END #layer
END #map
