Tsearch2 headline usage
От | Rajesh Kumar Mallah |
---|---|
Тема | Tsearch2 headline usage |
Дата | |
Msg-id | a97c77030506040426333d780e@mail.gmail.com обсуждение исходный текст |
Список | pgsql-sql |
<br /> Hi There,<br /><br /> We are using tsearch2 for FTS implementation. For highlighting the search term<br /> in theresult we are displaying the output of headline function which is <br /> supposed to tag (mark up) those stemmed wordsin the text that match any of the<br /> stemmed words in search term. The problem is that some initial part of the text<br/> is being truncated from the headline output. Can anyone please suggest on how<br /> to overcome this phenomenon.<br/><br /> tradein_clients=> SELECT headline( 'A Leading manufacturer & Exporter of TAJ Brand Icecream Plant & Dairy Equipments with complete plants in various capacities. Pasteuriser, Homogenizer, Surface Cooler,Plate Chiller, Ageing Vat, Ice Cream Continuous Freezer, Single Flavour Softy, Bulk Milk Coolers.' , to_tsquery('ice&cream&plant'), 'StartSel=<b>, StopSel=</b>' ) ;<br /> headline<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /><b>cream</b> <b>Plant</b> & Dairy Equipments with complete <b>plants</b> in variouscapacities. Pasteuriser, Homogenizer, Surface Cooler, Plate Chiller, Ageing Vat, <b>Ice</b> <b>Cream</b><br/> (1 row)<br /><br /> Regds<br /> Mallah.<br /><br /><br />
В списке pgsql-sql по дате отправления: