On 12/6/13, 7:03 PM, cbfgterfdy(at)zacglen(dot)net wrote:
> While "psql -H" is quite useful there is flaw when a query includes
> ts_headline(). The highlighting html gets escaped along with any other html
> special characters.
How would you address that? There is no way for psql or any other
client to know that the text data that is being returned is actually
HTML. A proper fix would be having an HTML data type, or having
ts_headline() return type XML.