\set ON_ERROR_STOP on DO $$ BEGIN IF current_database() <> 'track' THEN RAISE EXCEPTION 'track-setup.sql выполняется только в базе track'; END IF; END $$; CREATE EXTENSION IF NOT EXISTS pg_buffercache; CREATE OR REPLACE FUNCTION track_uuid7() RETURNS uuid LANGUAGE sql VOLATILE AS $$ SELECT encode( set_bit(set_bit(overlay(uuid_send(gen_random_uuid()) PLACING substring(int8send((extract(epoch FROM clock_timestamp()) * 1000)::bigint) FROM 3) FROM 1 FOR 6), 52, 1), 53, 1), 'hex')::uuid $$; CREATE OR REPLACE FUNCTION track_chat(k int) RETURNS uuid LANGUAGE sql IMMUTABLE AS $$ SELECT ('00000000-0000-7000-8000-' || lpad(to_hex(k), 12, '0'))::uuid $$; CREATE OR REPLACE FUNCTION track_user(u int) RETURNS uuid LANGUAGE sql IMMUTABLE AS $$ SELECT ('00000000-0000-7000-8001-' || lpad(to_hex(u), 12, '0'))::uuid $$; CREATE OR REPLACE FUNCTION track_message(k int, i int) RETURNS uuid LANGUAGE sql IMMUTABLE AS $$ SELECT (lpad(to_hex(k), 8, '0') || '-0000-7000-8002-' || lpad(to_hex(i), 12, '0'))::uuid $$;