[mapguide-users] Mapguide 3.0 Postgre view problem

[sebafr]

try this:

CREATE OR REPLACE VIEW public.route_lines_view AS
 SELECT grag.dp_oid,
    grag.dp_otype,
    grag.dp_subtype,
    grag.dp_ctype,
    grag.dp_mod,
    grag.dp_state,
    grag.shape,
    guide_generic_search_table( 'ditch.owner','piping.ditch',
'ditch.dp_oid=' || grag.dp_oid) as owner,
    guide_generic_search_table( 'ditch.length','piping.ditch',
'ditch.dp_oid=' || grag.dp_oid) as length
   FROM piping.grag

[]s
Seba





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-3-0-Postgre-view-problem-tp5298765p5298822.html
Sent from the MapGuide Users mailing list archive at Nabble.com.