make
make install
+The 'make install' step will need sufficient privileges to write
+to the Postgres extension directory, so 'sudo make install'
+might be needed.
+
+Installation can be done via the usual Postgres extension mechanism.
+create extension pduuid;
+
+The extension is re-locatable, so you can specify a schema if you
+like.
+
Installation can be done manually with:
psql -f uuid.sql
psql -f uninstall-uuid.sql
-Or as a postgres extension:
-create extension pduuid;
-
A pure postgres implementation is also supplied of just the generation
-functions in purepguuid.sql.
+functions in purepguuid.sql, though this is very inefficient, feature
+incomplete, and untested. It's there if you need it though.
Generation Functions:
are vanishingly low and it is safe to use for regular production uuid
generation.
-uuid_v3(uuid, text)
+uuid_v5(uuid, text)
returns a version 5 uuid using the supplied namespace uuid and the
given input string. This is an sha1 based uuid.
Numeric: treats the UUID as a 128 bit number and converts it to a numeric.
Bit(128) and bit varying: treats the uuid as a 128 bit vector.
+Casts to bit(n) where n is shorter than 128 will truncate
+the uuid. Where n is longer than 128, the bit vector
+will be zero extended.
Field extraction functions: