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: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
