SHARE
TWEET

Untitled

a guest Feb 12th, 2017 93 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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');
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top