On Thu, 20 Apr 2017 00:55:48 -0400, George Neuner
<gneuner2(at)comcast(dot)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