Re: tsearch2 questions

From: "hubert depesz lubaczewski" <depesz(at)gmail(dot)com>
To: "Joshua N Pritikin" <jpritikin(at)pobox(dot)com>
Cc: "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>, pgsql-general(at)postgresql(dot)org
Subject: Re: tsearch2 questions
Date: 2007-07-04 08:40:11
Message-ID: 9e4684ce0707040140x32492596rabd355ceecb8bdfd@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/4/07, Joshua N Pritikin <jpritikin(at)pobox(dot)com> wrote:
>
> Please mention that in the documentation:

dont you think this is perfeclty clear?

"If you want to do something specific with columns, you may write your very
own trigger function using plpgsql or other procedural languages (but not
SQL, unfortunately) and use it instead of tsearch2 trigger."

> what's about simple normalization formulae, like rank/(rank+1) ?
> I think you are suggesting that I use the best rank as the denominator
> for the rank column. Yes, I suppose that will work.

actually oleg supposed not to use best rank, but just use the formula as
given - rank/(rank+1) to get rank in range of 0 to 1.

depesz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2007-07-04 08:58:01 Re: Date for a week day of a month
Previous Message Joshua N Pritikin 2007-07-04 08:21:31 Re: tsearch2 questions