Skip to content

ivanyu/pg-uuids-v1-compare

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

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

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published