[PostgreSQL] Search - Content plugin SQL error

[ralain]

Steps to reproduce the issue

In Joomla running on PostgreSQL, search for a word that you know is present in an article, using the old search (not smart search.)

Expected result

At least one article hit in search results and no error.

Actual result

Zero article hits in search results.
Error message: An error has occurred.

System information (as much as possible)

Latest Staging.
PHP 7.1
PostgreSQL 9.6.1

Additional comments

The issue appears to arise because the GROUP_CONCAT() function is not available in PostgreSQL.

[ralain]

Closing as we have a PR: #13291

[alikon]

@ralain please reopen cause #13291 is not enough it fix the GROUP_CONCAT() issue,
but, there is another issue to solve with search plugin we are joining on different field type....

[ralain]

Yep, I noticed that and was just about to post a new issue.

[ralain]

@alikon see #13308