Thread: 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