Text search without dictionary ?

From: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Text search without dictionary ?
Date: 2009-06-09 11:32:50
Message-ID: C4DAC901169B624F933534A26ED7DF31010A516D@JENMAIL01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Mamin 2009-06-09 11:46:03 Re: Sum of multiplied deltas
Previous Message tamanna madaan 2009-06-09 08:37:15 postgres getting slow under heavy load though autivacuum is enabled