Strange behavior on to_tsquery() - Mailing list pgsql-hackers

From Rodrigo Hjort
Subject Strange behavior on to_tsquery()
Date
Msg-id CAAjEfRz+TCTWX=cG6gPx+sDpsa9QN16s9X6+4F1RkyR6vUBWsg@mail.gmail.com
Whole thread Raw
Responses Re: Strange behavior on to_tsquery()
List pgsql-hackers
Hello PG hackers,<br /><br />I created a <b>custom dictionary</b> (based on dict_int) and a search configuration and a
strangebehavior happens on <b>PostgreSQL 8.4.9</b>.<br /><br />When I invoke the following instruction several
times,<b>to_tsquery()</b> returns distinct results:<br /><br /><span style="font-family: courier
new,monospace;">catalog=>SELECT to_tsquery('custom', 'pi');</span><br style="font-family: courier new,monospace;"
/><spanstyle="font-family: courier new,monospace;"> to_tsquery </span><br style="font-family: courier new,monospace;"
/><spanstyle="font-family: courier new,monospace;">------------</span><br style="font-family: courier new,monospace;"
/><spanstyle="font-family: courier new,monospace;"> 'pi':*</span><br style="font-family: courier new,monospace;"
/><spanstyle="font-family: courier new,monospace;">(1 registro)</span><br style="font-family: courier new,monospace;"
/><brstyle="font-family: courier new,monospace;" /><span style="font-family: courier new,monospace;">catalog=>
SELECTto_tsquery('custom', 'pi');</span><br style="font-family: courier new,monospace;" /><span style="font-family:
couriernew,monospace;"> to_tsquery </span><br style="font-family: courier new,monospace;" /><span style="font-family:
couriernew,monospace;">------------</span><br style="font-family: courier new,monospace;" /><span style="font-family:
couriernew,monospace;"> 'pi'</span><br style="font-family: courier new,monospace;" /><span style="font-family: courier
new,monospace;">(1registro)</span><br /><br />Therefore, when I use <b>@@ operator</b> over a <b>tsvector</b> column in
mytable the result set is not always the same.<br /><br />1) Do you have any clue on what could be happening and how to
solvethis issue, please?<br /><br />2) Sometimes the value returned by <b>to_tsquery()</b> has a ":*" suffix. What does
thatmean?<br /><br />Thanks in advance.<br /><br />Best Regards,<br /><br />-- <br />Rodrigo Hjort<br /><a
href="http://www.hjort.co"target="_blank">www.hjort.co</a><br /><br /> 

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: ts_count
Next
From: Tom Lane
Date:
Subject: Re: Strange behavior on to_tsquery()