Seba, I have some additional question about the function. 1)Can I use CASE WHEN condition with this function I have situation that owner values are just numbers and I want to convert those values to some text. Sample: CASE WHEN owner = 1 then 'one' ELSE 'none' End
2) Can I have also multiple conditions when join values ....,'ditch.dp_oid=' || grag.dp_oid and 'ditch.some_other_id' || grag.some_other_id) Kajar -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Mapguide-3-0-Postgre-view-problem-tp5298765p5299171.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