On Tue, 19 Dec 2006, Magnus Hagander wrote:
On Tue, Dec 19, 2006 at 01:48:22PM +0530, Gurjeet Singh wrote:
On 12/19/06, Henrik Zagerholm <henke@xxxxxx> wrote:
Hello,
Searching after "tsearch"
5. PostgreSQL: Documentation: Manuals: PostgreSQL 7.4: Examples [0.1]
...tsearch and tsearch2Full text
indexingPrevHomeNextLimitationsUpPage Files User Comments No comments
could be found for this...
http://www.postgresql.org/docs/7.4/interactive/examples.html
Searching after "tsearch2"
An error occured while searching.
Searching after "tsearch2full"
An error occured while searching.
This error can be generalized to the reg-ex [::alpha::]+[::digit::]+
Examples:
A1
A2 etc...
Why is it so? =)
Seems to_tsvecto() returns NULL for tsearch2 or for, as you say,
anything that ends in a digit.
Oleg, can you comment on why this is happening? What can we do to fix
that?
Most probably, token type 'word' just doesn't indexed. If you
didnt' correct this from pgweb configuration:
-- we won't index/search some tokens
update pg_ts_cfgmap set dict_name = NULL
where tok_alias in ('email', 'url', 'sfloat', 'uri', 'float','word')
and ts_name = 'pg';
//Magnus
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
