Re: Tsearch2 - Error using tsquery object in GROUP BBY

> The query I'm executing has a GROUP BY clause and because I'm using the
> headline function I need my tsquery object in the SELECT clause and
> therefor also in the GROUP BY clause.
> BUT when executing the query I get the following error. -> "could not
> identify an ordering operator for type tsquery"

Which version do you use? Only 8.2 will have comparison operator for tsquery.

>
> How do I solve this?
Use subselect:
SELECT *, headline(..., to_tsquery()) FROM
{
SELECT .... GROUP BY ...
);

BTW, for performance reason, it might be useful to use limit in inner select -
headline function is slow enough.

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/