[Talk-us] Do we want overlaps to be rendered? Or do we want to wait for relation support that may never come?

[Phil! Gold]

* Nathan Edgars II <neroute2 at 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")
---- --- --