Advertisement
Guest User

Untitled

a guest
Feb 12th, 2017
192
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.18 KB | None | 0 0
  1. SELECT * FROM geocode.osm_addresses
  2. WHERE  to_tsvector('simple', unaccent(concat_ws(' ', country, city,street, housenumber, postcode)))
  3.     @@ plainto_tsquery('simple', 'farstrange 5');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement