I have another example:
```sql
-- freshly imported ile-de-france-latest.osm.pbf
paris=# SELECT
COALESCE(tags->'colour', tags->'color', 'red') as color
FROM planet_osm_line
WHERE osm_id = -3328716; -- Ligne 11 subway
color
---------
#d2d200
#d2d200
(2 rows)
```
vs.
```
--- Europe imported on 2024-09-30T20:21:15Z updated daily
europe=# SELECT
COALESCE(tags->'colour', tags->'color', 'red') as color
FROM planet_osm_line
WHERE osm_id = -3328716;
color
-------
red
red
(2 rows)
```
I still think something's fishy.
--
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2192#discussioncomment-11131327
You are receiving this because you are subscribed to this thread.
Message ID:
<osm2pgsql-dev/osm2pgsql/repo-discussions/2192/comments/[email protected]>
_______________________________________________
Tile-serving mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/tile-serving