On Wed, Jul 04, 2007 at 10:40:11AM +0200, hubert depesz lubaczewski wrote: > On 7/4/07, Joshua N Pritikin <[EMAIL PROTECTED]> 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."
>From where are you quoting? I was quoting from: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch2-ref.html > >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. OK, then what does the +1 mean in your formulae? Consider these results from [1]. rank/(rank+1): 0.19/.1 = 1.9, .1/.1 = 1, etc. That doesn't make sense. The reciprocal also doesn't make sense. So what does Oleg mean? I was guessing that Oleg meant to divide the rank column by the first rank, that is, by 0.19 so you would get 1, .52, .52, etc. id | headline | rank ----+-------------------------------------------------------+------ 3 | <b>crawling</b> over cobbles in a low <b>passage</b>. | 0.19 1 | <b>crawl</b> over cobbles leads inward to the west. | 0.1 4 | <b>passages</b> lead east, north, and south. | 0.1 5 | <b>crawl</b> slants up. | 0.1 7 | <b>passage</b> here is blocked by a recent cave-in. | 0.1 Am I being stupid? [1] http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch2-guide.html -- Make April 15 just another day, visit http://fairtax.org ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
