PostgreSQL function to compare version 1 (time-based) UUIDs by timestamps and counter, and tests for it
Scala PLpgSQL
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
src/test
.gitignore
LICENSE
README.md
build.sbt
create_uuids_v1_compare.sql

README.md

pg-uuids-v1-compare

PostgreSQL function to compare version 1 (time-based) UUIDs based on timestamps, and tests for it.

Example:

SELECT uuids_v1_compare(uuid('762ca430-eed5-11e5-8ca8-4bebdf3c407a'),
                        uuid('762cf250-eed5-11e5-8ca8-4bebdf3c407a'))

uuids_v1_compare
smallint
----------------
-1

A blog post about it.