Contents

CREATE OR REPLACE FUNCTION hash_64(
  _stream_name varchar
)
RETURNS bigint
AS $$
DECLARE
  hash bigint;
BEGIN
  select left('x' || md5(_stream_name), 16)::bit(64)::bigint into hash;
  return hash;
END;
$$ LANGUAGE plpgsql
IMMUTABLE;

Version data entries

31 entries across 31 versions & 2 rubygems

Version	Path
evt-message_store-postgres-database-0.10.1.1	database/functions/hash-64.sql
evt-message_store-postgres-database-0.10.1.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.10.0.1	database/functions/hash-64.sql
evt-message_store-postgres-database-0.10.0.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.9.0.1	database/functions/hash-64.sql
evt-message_store-postgres-database-0.9.0.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.8.0.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.7.1.1	database/functions/hash-64.sql
evt-message_store-postgres-database-0.7.1.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.7.0.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.6.0.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.5.0.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.4.1.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.4.0.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.3.0.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.2.0.2	database/functions/hash-64.sql
evt-message_store-postgres-database-0.2.0.1	database/functions/hash-64.sql
evt-message_store-postgres-database-0.2.0.0	database/functions/hash-64.sql
evt-message_store-postgres-database-0.1.4.3	database/functions/hash-64.sql
evt-message_store-postgres-database-0.1.4.2	database/functions/hash-64.sql