Re: Text search without dictionary ?

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Text search without dictionary ?
Date: 2009-06-09 11:51:39
Message-ID: Pine.LNX.4.64.0906091549040.17118@sn.sai.msu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc,

we'll probably add option to simple dictionary for 8.5, but I think
if you were able to write your own parser it'd be not difficult to
write 'simplest' dictionary, which does nothing. Just take simple dictionary
and remove lowercasing :)

Oleg
On Tue, 9 Jun 2009, Marc Mamin wrote:

>
> Hello,
>
> I have some columns containig list of codes (e.g. 'Af45De Uz76 I98ht ...
> ')
> and I'd like to build full text search indexes on them.
>
> As these strings are basically a list of IDs , I don't need any
> dictionary.
> I've built an own simplified parser whose output is sufficient.
>
> My concern is about the lowercase transformation of the simple
> dictionary
> which anyway don't reduce the number of lexemes significantly.
>
> I could easily workaround this while rechecking the strings,
> but I wonder if there is a simple way to disable the lowercse
> transformation as I don't need it...
>
> Maybe someone can also point me to some documentation about writing my
> own dummy dictionnary?
>
>
> (I'm currently experimenting with 8.3.6, but we will probably implement
> such functionalities only with 8.4)
>
>
>
>
> Thanks,
>
> Marc Mamin
>
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2009-06-09 11:58:46 Re: Block_Size on NTFS
Previous Message Marc Mamin 2009-06-09 11:46:03 Re: Sum of multiplied deltas