Matt,<div><br></div><div>Just picked up on the thead, sorry for the late posting. In PostgreSQL, for full-text indexing in TSearch2 (don't know if your FTS experience is with PG), you can also build with plainto_tsquery(), and if you want to avoid the dictionary stemming etc., prepare the index and use the search with 'simple' - i.e. to_tsvector('simple',my_field). This allows you to match words from a supplied phrase, rather than the phrase itself as with @@, and use rankings, similarity etc. to score your results.</div>
<div><br></div><div>Alternatively, preparing a btree index with a <span class="Apple-style-span" style="font-family: monospace; font-size: 14px; line-height: 18px; ">varchar_pattern_ops</span><span class="Apple-style-span" style="font-size: 14px; line-height: 18px; "><font class="Apple-style-span" face="arial, helvetica, sans-serif"> or </font></span><span class="Apple-style-span" style="font-family: monospace; font-size: 14px; line-height: 18px; ">text_pattern_op</span><span class="Apple-style-span" style="font-size: 14px; line-height: 18px; "><font class="Apple-style-span" face="arial, helvetica, sans-serif">s opclass (see <span class="Apple-style-span" style="font-family: arial; line-height: normal; font-size: small; "><a href="http://www.postgresql.org/docs/current/static/indexes-opclass.html">http://www.postgresql.org/docs/current/static/indexes-opclass.html</a><span class="Apple-style-span" style="font-family: arial, helvetica, sans-serif; font-size: 14px; line-height: 18px; ">) allows the use of like, so long as the search is anchored at the start of the term.</span></span></font></span></div>
<meta http-equiv="content-type" content="text/html; charset=utf-8"><div><font class="Apple-style-span" size="4"><span class="Apple-style-span" style="font-size: 14px; line-height: 18px;"><font class="Apple-style-span" face="arial, helvetica, sans-serif"><br>
</font></span></font></div><div><font class="Apple-style-span" size="4"><span class="Apple-style-span" style="font-size: 14px; line-height: 18px;"><font class="Apple-style-span" face="arial, helvetica, sans-serif">Steve</font></span></font></div>
<div><font class="Apple-style-span" face="monospace" size="4"><span class="Apple-style-span" style="font-size: 14px; line-height: 18px;"><br></span></font></div><div><font class="Apple-style-span" face="monospace" size="4"><span class="Apple-style-span" style="font-size: 14px; line-height: 18px;"><br>
</span></font><br><div class="gmail_quote">On 5 May 2010 17:25, mattmendick <span dir="ltr"><<a href="mailto:matt.mendick@pictometry.com">matt.mendick@pictometry.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<br>
Andy-<br>
<br>
Thanks a ton for taking a look at this for me. In looking around some more<br>
talking about variable substitution, I found that I can do a FILTER like you<br>
mentioned in the layer section of the mapfile. I could do a:<br>
<br>
FILTER "city @@ ts_vector('%mycitysearch%')"<br>
<br>
and then in the mapserver request url, add a &mycitysearch=new york, this<br>
will work (I tried it using FILTER "city = '%mycitysearch%'", and it worked<br>
perfectly. I don't have the full-text set up yet on my server, but i've done<br>
it in the past.) It's too bad I can't do it with the normal PropertyIsLike<br>
syntax, but it seems that if I wanted to hack up the code for our own<br>
installation, I could replace the sql building code with my own.<br>
<br>
Thanks very much for your help, you've answered a lot of my questions!<br>
<br>
-Matt<br>
<font color="#888888">--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/postgres-fulltext-search-tp5009033p5009786.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/postgres-fulltext-search-tp5009033p5009786.html</a><br>
Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
</font><div><div></div><div class="h5">_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div></div></blockquote></div><br></div>