Tsearch2 - Error using tsquery object in GROUP BBY queries - Mailing list pgsql-general

From Henrik Zagerholm
Subject Tsearch2 - Error using tsquery object in GROUP BBY queries
Date
Msg-id CE3399FE-36AC-4952-97DE-C935301DEB34@mac.se
Whole thread Raw
Responses Re: Tsearch2 - Error using tsquery object in GROUP BBY  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-general
Hello list,

I've set up tsearch2 to handle full-text searches (obviously :)).

I have a problem I can't find a solution to and it feels its tsquery
objects fault.

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"

How do I solve this?

Regards,
Henrik



pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Blob fields and backups
Next
From: "Isak Hansen"
Date:
Subject: Re: Separation of clients' data within a database