Re: 8.3 version of ts_headline - Mailing list pgsql-hackers

Andreas Joseph Krogh <andreak@officenet.no> writes:
> In 8.2 this produces an error:

> SELECT headline('default', 'a b c', 'c'::tsquery,
> 'StartSel=<span class="style1">, StopSel=</span>');
> ERROR:  syntax error
> DETAIL:  Syntax error in position 15.

Sure you don't just need to quote the values?

regression=# SELECT ts_headline('english', 'a b c', 'c'::tsquery,
$$StartSel='<span class="style1">', StopSel='</span>'$$);           ts_headline            
-----------------------------------a b <span class="style1">c</span>
(1 row)

        regards, tom lane