Advertisement
Guest User

Untitled

a guest
Oct 6th, 2015
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. CREATE INDEX index_companies_on_addresses_on_zipcode ON companies USING gin ((addresses -> 'zipcode'));
  2.  
  3. execute "CREATE INDEX index_companies_on_addresses_on_zipcode ON companies USING gin ((addresses -> 'zipcode'));"
  4.  
  5. add_index :companies, :addresses, using: :gin
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement