Skip to content

Instantly share code, notes, and snippets.

@kshahkshah

kshahkshah/gist:4986726320782d5b592b7151281189cd

Created December 12, 2016 15:37
Show Gist options
  • Save kshahkshah/4986726320782d5b592b7151281189cd to your computer and use it in GitHub Desktop.
Save kshahkshah/4986726320782d5b592b7151281189cd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT similarity(stored_value, 'my comparison value') as similarity
FROM all_store_values
ORDER BY similarity DESC, stored_value
LIMIT 1
CREATE INDEX trgm_idx ON all_store_values USING gist (stored_value gist_trgm_ops);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment