[openstreetmap/openstreetmap-website] Switch to TIMESTAMP WITH TIME ZONE for current_* tables (#375)

mmd notifications at github.com
Wed Nov 21 14:11:37 UTC 2018


Quick question on this one. Cgimap has some queries like the example eblow. Assuming we're running the server at non-UTC-0 time, would we need to apply to changes to the code then once the data type has an additional `with local time zone`? My assumption would be yes here, so we'd probably need a Github issue on cgimap to cover this change.

```C++
  m_connection.prepare("extract_nodes",
    "SELECT n.id, n.latitude, n.longitude, n.visible, "
        "to_char(n.timestamp,'YYYY-MM-DD\"T\"HH24:MI:SS\"Z\"') AS timestamp, "
        "n.changeset_id, n.version, array_agg(t.k) as tag_k, array_agg(t.v) as tag_v "
      "FROM current_nodes n "
        "LEFT JOIN current_node_tags t ON n.id=t.node_id "
      "WHERE n.id = ANY($1) "
"GROUP BY n.id ORDER BY n.id")
```

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/issues/375#issuecomment-440674854
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20181121/6668e1e8/attachment.html>


More information about the rails-dev mailing list