Tsearch2 - Error using tsquery object in GROUP BBY queries

Поиск
Список
Период
Сортировка
От Henrik Zagerholm
Тема Tsearch2 - Error using tsquery object in GROUP BBY queries
Дата
Msg-id CE3399FE-36AC-4952-97DE-C935301DEB34@mac.se
обсуждение исходный текст
Ответы Re: Tsearch2 - Error using tsquery object in GROUP BBY
Список 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 по дате отправления: