[openstreetmap/openstreetmap-website] Clarify that there is no pure SQL version of xid_to_int4 for diff replication. (7fb5bca)

Tim Waters notifications at github.com
Sun Oct 20 21:38:49 UTC 2019


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

-- 
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/commit/7fb5bcaf3f9775ee1de185efb3164a100ecccdc3#commitcomment-35582035
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20191020/798e7af0/attachment.html>


More information about the rails-dev mailing list