Skip to content

Instantly share code, notes, and snippets.

@kodekracker

kodekracker/pseudo_enc_bigint.sql

Forked from dariushoule/pseudo_enc_bigint.sql
Created September 19, 2020 16:49
Show Gist options
  • Save kodekracker/17cfd04c4f42e6dca5005845ea839bf5 to your computer and use it in GitHub Desktop.
Save kodekracker/17cfd04c4f42e6dca5005845ea839bf5 to your computer and use it in GitHub Desktop.
Download ZIP
bigint feistel pseudo encrypt
Raw
pseudo_enc_bigint.sql
CREATE OR REPLACE FUNCTION pseudo_encrypt(VALUE bigint) returns bigint AS $$
DECLARE
l1 bigint;
l2 bigint;
r1 bigint;
r2 bigint;
i int:=0;
BEGIN
l1:= (VALUE >> 32) & 4294967295::bigint;
r1:= VALUE & 4294967295;
WHILE i < 3 LOOP
l2 := r1;
r2 := l1 # ((((1366.0 * r1 + 150889) % 714025) / 714025.0) * 32767*32767)::int;
l1 := l2;
r1 := r2;
i := i + 1;
END LOOP;
RETURN ((r1::bigint << 32) + l1);
END;
$$ LANGUAGE plpgsql strict immutable;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment