Re: [GENERAL] full text search on hstore or json with materialized view? - Mailing list pgsql-general

On Thu, 20 Apr 2017 00:55:48 -0400, George Neuner
<gneuner2@comcast.net> wrote:

Doh!

>  SELECT count(distinct s.id)
>    FROM  samples_lg_txt AS s
>    JOIN  keys AS k ON k.id = s.key
>    WHERE (k.name = 'key1' AND s.tsv @@ to_query('value1')
>       OR (k.name = 'key2' AND s.tsv @@ to_query('value2')
>
>  :
>
>  SELECT count(distinct id)
>    FROM  samples_lg_txt
>    WHERE (key = 'key1' AND tsv @@ to_query('value1')
>       OR (key = 'key2' AND tsv @@ to_query('value2')


All the WHERE clauses need closing parentheses.

Time for bed,
George