Feature Requests item #2175942, was opened at 2008-10-18 05:37 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2175942&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL - general Group: None Status: Open Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Nobody/Anonymous (nobody) Summary: String aggregate function (group_concat) Initial Comment: It would be a really nice addiction to the 'helpful examples' base if some examples could be added with respect to the processing of functions. I took a peak in the sql test directory but non of the examples really fits the bill. What I want is an equivalent of the http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat MySQL function, or STRAGG in Orace. The use case is on the fly GIS creation polyline creation. SELECT '(' || x || ',' || y || ')' INTO out FROM way_nds, nodes_legacy WHERE thisway = way AND nodes_legacy.id = to_node; Would select a list of (x,y) that can be concatted to polyline((..), (..)) this would allow for example OGR/MapServer to make use of my dataset directly without going the way of making a hybride dataset that stores the POLYLINE(...) in my way column. Quick and dirty solutions are willingly accepted. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2175942&group_id=56967 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
