Skip to content

Instantly share code, notes, and snippets.

@mikepaszkiewicz

mikepaszkiewicz/gist:073440a413f71b37b1160db892ff9705

Created January 4, 2018 17:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mikepaszkiewicz/073440a413f71b37b1160db892ff9705 to your computer and use it in GitHub Desktop.
Save mikepaszkiewicz/073440a413f71b37b1160db892ff9705 to your computer and use it in GitHub Desktop.
Download ZIP
Snips: PostgreSQL - Create searchable text index on integer field
Raw
gistfile1.txt
create index concurrently on transactions (order_number) USING GIN(order_number::text gin_trgm_ops)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment