[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:
-------------- 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