Postgres Pro
Downloads
Home   >   mailing lists

tsearch2 headline options - Mailing list pgsql-general

From Jan Sunavec
Subject tsearch2 headline options
Date
Msg-id op.t4ba0mlsc8yns6@akela-pc.chello.sk
Whole thread Raw
In response to Re: convert function  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: tsearch2 headline options
List pgsql-general
Tree view 
Hi all

I have following problem when I use this

select headline('asd asd asd asd asd asd asd asd asd asd asd asd more more
more more more more more', to_tsquery('asd'), '');

I got this

"<b>asd</b> <b>asd</b> <b>asd</b> <b>asd</b> <b>asd</b> <b>asd</b>
<b>asd</b> <b>asd</b> <b>asd</b> <b>asd</b> <b>asd</b> <b>asd</b> more
more more"

So result is shorted than original text. I tryed set MinWords and
MaxWords. But it doesn't help me. So question is how can I get original
text?

Best regards

    John

pgsql-general by date:

Previous
From: dterrors@hotmail.com
Date:
Subject: A counter argument about DISTINCT and GROUP BY in PostgreSQL
Next
From: Goboxe
Date:
Subject: Using syslog on pg for Windows