Skip to content

Instantly share code, notes, and snippets.

@mvodep

mvodep/20220312.compare.sql

Created March 14, 2022 19:20
Show Gist options
  • Save mvodep/efcc9240662f1fd0548874a5b8e45102 to your computer and use it in GitHub Desktop.
Save mvodep/efcc9240662f1fd0548874a5b8e45102 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
20220312.compare.sql
SELECT '123' <-> '123abcd', '123abcd'
UNION
SELECT '123' <-> 'a123bcd', 'a123bcd'
UNION
SELECT '123' <-> 'ab123cd', 'ab123cd'
UNION
SELECT '123' <-> 'abcd123', 'abcd123'
?column? |?column?|
---------+--------+
0.9090909|a123bcd |
0.8|abcd123 |
0.6666666|123abcd |
0.9090909|ab123cd |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment