Full Text Partial Match at begining
Is it possible to match "%text' in Postgresql 9 Full Text.
select to_tsvector('english','this is advantage') @@ to_tsquery('tage');
f
I need to get result true for this type of matching.
Any idea please.
AI Rumman <rummandba@gmail.com> writes:
Is it possible to match "%text' in Postgresql 9 Full Text.
See http://www.sai.msu.su/~megera/wiki/wildspeed
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
On Thu, 02 Dec 2010 17:34:28 +0100, Dimitri Fontaine
<dimitri@2ndQuadrant.fr> wrote:
AI Rumman <rummandba@gmail.com> writes:
Is it possible to match "%text' in Postgresql 9 Full Text.
See http://www.sai.msu.su/~megera/wiki/wildspeed
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
I saw speed result of this and those are surprising. I saw source code,
too. Can be this index used directly on text column? I mean if we will
create this index for 100 characters long text it looks like the index will
take 100^2=10000, because it's set of all shifts.
--
----------
Radosław Smogura
http://www.softperience.eu