Thomas Nyberg <tomuxiong@xxxxxxx> writes: > Here both 'hello' and 'hello world' are ranked equally highly when > searching with 'hello'. What I'm wondering is, is there a way within > postgres to have it match higher to just 'hello' than 'hello world'? > I.e. something like it slightly down-weights extraneous terms? Of course > in general I don't know the query or the field strings ahead of time. Read the documentation for ts_rank --- there's a normalization option for that. I'd also suggest you might prefer using ts_rank_cd, which is supposed to penalize cases where the matching words aren't close together. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
