<p>Could the xid_to_int4 function part of <a href="https://github.com/openstreetmap/osmosis/blob/master/package/script/contrib/apidb_0.6_osmosis_xid_indexing.sql">https://github.com/openstreetmap/osmosis/blob/master/package/script/contrib/apidb_0.6_osmosis_xid_indexing.sql</a> be a pure sql alternative? I tried entering in a few numbers with this and with the C functions e.g. <code>select xid_to_int4('123'::xid);</code> and it appeared to produce the same result. I've no idea about performance though, nor did I delve into fully testing it. Cheers :)</p>

<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/commit/7fb5bcaf3f9775ee1de185efb3164a100ecccdc3?email_source=notifications&email_token=AAK2OLMMBBZWGLKB2PWWJP3QPTFWTA5CNFSM4JCWGD7KYY3PNVWWK3TUL52HS4DFVVBW63LNNF2EG33NNVSW45FKMNXW23LFNZ2F62LEZYBB54CT#commitcomment-35582035">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLNGUO5YKZH6Y37IDFDQPTFWTANCNFSM4JCWGD7A">unsubscribe</a>.<img src="https://github.com/notifications/beacon/AAK2OLMZVI6T3O33DTWCMT3QPTFWTA5CNFSM4JCWGD7KYY3PNVWWK3TUL52HS4DFVVBW63LNNF2EG33NNVSW45FKMNXW23LFNZ2F62LEZYBB54CT.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/commit/7fb5bcaf3f9775ee1de185efb3164a100ecccdc3?email_source=notifications\u0026email_token=AAK2OLMMBBZWGLKB2PWWJP3QPTFWTA5CNFSM4JCWGD7KYY3PNVWWK3TUL52HS4DFVVBW63LNNF2EG33NNVSW45FKMNXW23LFNZ2F62LEZYBB54CT#commitcomment-35582035",
"url": "https://github.com/openstreetmap/openstreetmap-website/commit/7fb5bcaf3f9775ee1de185efb3164a100ecccdc3?email_source=notifications\u0026email_token=AAK2OLMMBBZWGLKB2PWWJP3QPTFWTA5CNFSM4JCWGD7KYY3PNVWWK3TUL52HS4DFVVBW63LNNF2EG33NNVSW45FKMNXW23LFNZ2F62LEZYBB54CT#commitcomment-35582035",
"name": "View Commit"
},
"description": "View this Commit on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>