solution 1: (for programers people !) note: '' is two Single quotation marks
guide_generic_search_table('CASE when owner = 1 THEN ''one'' when owner =
2 then ''TWO'' END ', 'piping.pipe', 'pipe.dp_oid=' || symg.dp_oid) AS owner
solution 2: (for normal people!)
create a view vw_pipe with the field CASE when owner = 1 THEN 'one' when
owner = 2 then 'TWO' END and use then on fuction:
guide_generic_search_table('field_case', 'piping.vw_pipe', 'pipe.dp_oid=' ||
symg.dp_oid) AS owner
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Mapguide-3-0-Postgre-view-problem-tp5298765p5299224.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
