[openstreetmap/openstreetmap-website] Add pure SQL version of xid_to_int4. (#2408)

[Matt Amos]

Thanks to @mmd-osm and @timwaters for [pointing out](https://github.com/openstreetmap/openstreetmap-website/pull/2383#discussion_r333039034) [there's a pure SQL version of `xid_to_int4`](https://github.com/openstreetmap/openstreetmap-website/pull/2383#commitcomment-35582035), so we might as well include that. I wasn't aware that anyone was using this, but @gravitystorm [knows of some (perhaps former) users](https://github.com/openstreetmap/openstreetmap-website/pull/2383#commitcomment-35587159). So it looks like perhaps this is worth including for completeness / parity?

:crossed_fingers: we get to replace all this soon with something compatible with PostgreSQL 10+.

You can view, comment on, or merge this pull request online at:

  https://github.com/openstreetmap/openstreetmap-website/pull/2408

-- Commit Summary --

  * Add pure SQL version of xid_to_int4.

-- File Changes --

    M CONFIGURE.md (2)
    M db/functions/functions.sql (30)

-- Patch Links --

https://github.com/openstreetmap/openstreetmap-website/pull/2408.patch
https://github.com/openstreetmap/openstreetmap-website/pull/2408.diff

-- 
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/pull/2408
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20191021/fecde96f/attachment.html>