search

lpalli / openaddresses

Automatically exported from code.google.com/p/openaddresses
0 stars 0 forks source link

Search with FTS: use ts_lexize #38

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
SELECT distinct street
FROM address
WHERE geom && 'BOX(6.61879551 46.51187241, 6.62879551 46.52187241)'::box2d
  AND
ST_Distance(geom, ST_GeomFromText('POINT(6.62379551 46.51687241)', 4326)) < 
0.005
  AND 
tsvector_street @@ to_tsquery(ts_lexize('english_stem','chem')::text||':* & 
d:* & f:*')
  limit 15;

Original issue reported on code.google.com by cedric.m...@gmail.com on 7 Apr 2010 at 11:30

GoogleCodeExporter commented 9 years ago

Original comment by cedric.m...@gmail.com on 7 Apr 2010 at 11:30

GoogleCodeExporter commented 9 years ago 
Not a good idea. Other solutions found.

Original comment by cedric.m...@gmail.com on 9 Apr 2010 at 7:32