Re: [PATCH] Implement uuid_version()
José Luis Tallón <jltallon@adv-solutions.net>
From: Jose Luis Tallon <jltallon@adv-solutions.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2019-04-07T13:38:44Z
Lists: pgsql-hackers
Attachments
- uuid_version-v2.patch (text/x-patch) patch v2
On 6/4/19 18:35, Tom Lane wrote: > Jose Luis Tallon <jltallon@adv-solutions.net> writes: >> While working on an application, the need arose to be able >> efficiently differentiate v4/v5 UUIDs (for use in partial indexes, among >> others) >> ... so please find attached a trivial patch which adds the >> functionality. > No particular objection... > >> I'm not sure whether this actually would justify a version bump for >> the OSSP-UUID extension > Yes. Basically, once we've shipped a given version of an extension's > SQL script, that version is *frozen*. Anything at all that you want > to do to it has to be done in an extension update script, because > otherwise there's no clean migration path for users. Got it, and done. Please find attached a v2 patch with the upgrade script included. Thank you for taking a look. Your time is much appreciated :) J.L.
Commits
-
Add gen_random_uuid function
- 5925e5549890 13.0 landed
-
Add a 64-bit hash function for type hstore.
- eb6f29141bed 12.0 cited