<p>Thanks to <a class="user-mention" data-hovercard-type="user" data-hovercard-url="/hovercards?user_id=5842757" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/mmd-osm">@mmd-osm</a> and <a class="user-mention" data-hovercard-type="user" data-hovercard-url="/hovercards?user_id=48941" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/timwaters">@timwaters</a> for <a href="https://github.com/openstreetmap/openstreetmap-website/pull/2383#discussion_r333039034" data-hovercard-type="pull_request" data-hovercard-url="/openstreetmap/openstreetmap-website/pull/2383/hovercard">pointing out</a> <a href="https://github.com/openstreetmap/openstreetmap-website/pull/2383#commitcomment-35582035" data-hovercard-type="pull_request" data-hovercard-url="/openstreetmap/openstreetmap-website/pull/2383/hovercard">there's a pure SQL version of <code>xid_to_int4</code></a>, so we might as well include that. I wasn't aware that anyone was using this, but <a class="user-mention" data-hovercard-type="user" data-hovercard-url="/hovercards?user_id=360803" data-octo-click="hovercard-link-click" data-octo-dimensions="link_type:self" href="https://github.com/gravitystorm">@gravitystorm</a> <a href="https://github.com/openstreetmap/openstreetmap-website/pull/2383#commitcomment-35587159" data-hovercard-type="pull_request" data-hovercard-url="/openstreetmap/openstreetmap-website/pull/2383/hovercard">knows of some (perhaps former) users</a>. So it looks like perhaps this is worth including for completeness / parity?</p>
<p><g-emoji class="g-emoji" alias="crossed_fingers" fallback-src="https://github.githubassets.com/images/icons/emoji/unicode/1f91e.png">🤞</g-emoji> we get to replace all this soon with something compatible with PostgreSQL 10+.</p>

<hr>

<h4>You can view, comment on, or merge this pull request online at:</h4>
<p>  <a href='https://github.com/openstreetmap/openstreetmap-website/pull/2408'>https://github.com/openstreetmap/openstreetmap-website/pull/2408</a></p>

<h4>Commit Summary</h4>
<ul>
  <li>Add pure SQL version of xid_to_int4.</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/2408/files#diff-0">CONFIGURE.md</a>
    (2)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/openstreetmap/openstreetmap-website/pull/2408/files#diff-1">db/functions/functions.sql</a>
    (30)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/openstreetmap/openstreetmap-website/pull/2408.patch'>https://github.com/openstreetmap/openstreetmap-website/pull/2408.patch</a></li>
  <li><a href='https://github.com/openstreetmap/openstreetmap-website/pull/2408.diff'>https://github.com/openstreetmap/openstreetmap-website/pull/2408.diff</a></li>
</ul>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/pull/2408?email_source=notifications&email_token=AAK2OLNQC6LAQAYVCYHXIITQPWXWLA5CNFSM4JC5UBA2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HTFUQ4A">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLL4DUWV6RHNYUHIV33QPWXWLANCNFSM4JC5UBAQ">unsubscribe</a>.<img src="https://github.com/notifications/beacon/AAK2OLJYBH3XCXDC77USD43QPWXWLA5CNFSM4JC5UBA2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HTFUQ4A.gif" height="1" width="1" alt="" /></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/pull/2408?email_source=notifications\u0026email_token=AAK2OLNQC6LAQAYVCYHXIITQPWXWLA5CNFSM4JC5UBA2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HTFUQ4A",
"url": "https://github.com/openstreetmap/openstreetmap-website/pull/2408?email_source=notifications\u0026email_token=AAK2OLNQC6LAQAYVCYHXIITQPWXWLA5CNFSM4JC5UBA2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HTFUQ4A",
"name": "View Pull Request"
},
"description": "View this Pull Request on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>