<div class="WordSection1"><p class="MsoNormal">PostgreSQL 9.3.x<p class="MsoNormal">I am looking for really good
documentationon how to do the following.<p class="MsoNormal"> <p class="MsoNormal">Use Case<p class="MsoNormal">I have
aweb application that will be storing into a table large blocks of HTML web content. Users will then want to search
thesefields for phrases. What is the best strategy for handling this in PostgreSQL? <p class="MsoNormal"> <p
class="MsoNormal">Whatwould the SQL look like? <p class="MsoNormal">What data type should the web content field be in
thetable? <p class="MsoNormal">Is there a way to set up the SQL so that matches are best match to least accurate
match?<pclass="MsoNormal">Etc…<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal">Thanks,<p class="MsoNormal"> <p class="MsoNormal"><a
href="http://illinois.edu/person/lance">LanceCampbell</a><p class="MsoNormal">Software Architect<p
class="MsoNormal">WebServices at Public Affairs<p class="MsoNormal">217-333-0382 <p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><ahref="http://illinois.edu/"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue;text-decoration:none"><imgalt="University of
Illinoisat Urbana-Champaign logo" border="0" height="25" id="Picture_x0020_1" src="cid:image001.png@01CFF4F1.3F732480"
width="150"/></span></a><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue"></span><p
class="MsoNormal"> <pclass="MsoNormal"> </div>