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.
_______________________________________________
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
