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

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

  1. Add gen_random_uuid function

  2. Add a 64-bit hash function for type hstore.