* Nathan Edgars II <nerou...@gmail.com> [2011-05-10 06:31 -0400]: > If that were so, it would be a lot simpler to use wrap_character=";" > like the motorway_junction code does.
One thought that I've had (but not taken time to experiment with, so you're obviously under no obligation to follow up) is to use the PostgreSQL regexp_split_to_table() function to split refs on semicolons. That gives you the original way replicated in the SQL results with a different ref for each row. Compare the output of this: SELECT name, ref FROM planet_osm_line WHERE ref LIKE '%;%' LIMIT 10; to this: SELECT name, regexp_split_to_table(ref, '; *') FROM planet_osm_line WHERE ref LIKE '%;%' LIMIT 10; -- ...computer contrarian of the first order... / http://aperiodic.net/phil/ PGP: 026A27F2 print: D200 5BDB FC4B B24A 9248 9F7A 4322 2D22 026A 27F2 --- -- Yes, yes. Zathras is used to being beast of burden to other people's needs. Very sad life. Probably have very sad death, but at least there is symmetry. -- Zathras (Babylon 5, "War Without End") ---- --- -- _______________________________________________ Talk-us mailing list Talk-us@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-us