Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 6FA141337B92 for ; Sat, 19 Feb 2011 00:25:05 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 85773-03 for ; Sat, 19 Feb 2011 04:24:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from momjian.us (momjian.us [70.90.9.53]) by mail.postgresql.org (Postfix) with ESMTP id 72FCA1337B4F for ; Sat, 19 Feb 2011 00:24:57 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id p1J4OsP00622; Fri, 18 Feb 2011 23:24:54 -0500 (EST) From: Bruce Momjian Message-Id: <201102190424.p1J4OsP00622@momjian.us> Subject: Re: prefix search in tsearch In-Reply-To: To: Oleg Bartunov , Erik Rijkers , pgsql-docs@postgresql.org Date: Fri, 18 Feb 2011 23:24:54 -0500 (EST) X-Mailer: ELM [version 2.4ME+ PL124 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.361 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FSL_RU_URL=2.271, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201102/61 X-Sequence-Number: 6409 I came up with some better wording, which I have applied: This query will match any word in a tsvector that begins with super. Note that prefixes are first processed by text search configurations, which means this comparison returns true: --------------------------------------------------------------------------- bruce wrote: > > I applied a modified documentation patch (attached) that includes Oleg's > suggestions. > > --------------------------------------------------------------------------- > > Oleg Bartunov wrote: > > Erik, > > > > I think it'd be more clear if you say not 'stemmed', but processed in > > according to configuration. Here is an example: > > > > $SHAREDIR/tsearch_data/my_synonyms.syn contains one line: > > one 1 > > > > > > CREATE TEXT SEARCH DICTIONARY my_synonym ( > > TEMPLATE = synonym, > > SYNONYMS = my_synonyms > > ); > > > > ALTER TEXT SEARCH CONFIGURATION english > > ALTER MAPPING FOR asciiword > > WITH my_synonym, english_stem; > > > > > > test=# select 'one'::tsvector @@ to_tsquery('english','one:*'); > > ?column? > > ---------- > > f > > (1 row) > > > > because 'one' was processed by my_synonym dictionary. > > > > test=# select ts_debug('english','one'); > > ts_debug > > ------------------------------------------------------------------------------ > > (asciiword,"Word, all ASCII",one,"{my_synonym,english_stem}",my_synonym,{1}) > > (1 row) > > > > > > > > On Tue, 31 Aug 2010, Erik Rijkers wrote: > > > > > [docs from cvs HEAD] > > > > > > I found the text-search documentation a little unclear about 'prefix search'; specifically, the > > > examples do not show that the so-called 'prefix' is first stemmed, before it is used as prefix. > > > > > > For instance, the following can be a little surprising: > > > > > > SELECT to_tsvector( 'postgraduate' ) @@ to_tsquery( 'postgres:*' ); > > > ?column? > > > ---------- > > > t > > > (1 row) > > > > > > Because prefix search is such an important functionality I think this should be better explained, > > > which I hope the attached doc-patch does. > > > > > > (In textsearch.sgml is another mention + example of prefix search, perhaps it should be extended a > > > little there too - which I'm happy to do as well, but I first wanted to see if you agree that it > > > is a little too obscure as it stands) > > > > > > > > > Erik Rijkers > > > > > > > Regards, > > Oleg > > _____________________________________________________________ > > Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), > > Sternberg Astronomical Institute, Moscow University, Russia > > Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ > > phone: +007(495)939-16-83, +007(495)939-23-83 > > > > -- > > Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-docs > > -- > Bruce Momjian http://momjian.us > EnterpriseDB http://enterprisedb.com > > + It's impossible for everything to be true. + -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. +