Created
May 29, 2020 22:32
-
-
Save MNoorFawi/ca8b420b0da01fa6d428442699aa49a7 to your computer and use it in GitHub Desktop.
Hamming Distance in PostgreSQL Database
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE FUNCTION hamming_distance( | |
A0 bigint, A1 bigint, A2 bigint, A3 bigint, | |
B0 bigint, B1 bigint, B2 bigint, B3 bigint | |
) | |
RETURNS integer AS $$ | |
BEGIN | |
RETURN | |
bits_count(A0 # B0) + | |
bits_count(A1 # B1) + | |
bits_count(A2 # B2) + | |
bits_count(A3 # B3); | |
END; | |
$$ LANGUAGE plpgsql; | |
-- another one to accept only integer (coming from python calls mainly) | |
CREATE OR REPLACE FUNCTION hamming_distance( | |
A0 integer, A1 integer, A2 integer, A3 integer, | |
B0 integer, B1 integer, B2 integer, B3 integer | |
) | |
RETURNS integer AS $$ | |
BEGIN | |
RETURN | |
bits_count(A0 # B0) + | |
bits_count(A1 # B1) + | |
bits_count(A2 # B2) + | |
bits_count(A3 # B3); | |
END; | |
$$ LANGUAGE plpgsql; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment