Re: [GENERAL] full text search on hstore or json with materialized view?

Поиск
Список
Период
Сортировка
От George Neuner
Тема Re: [GENERAL] full text search on hstore or json with materialized view?
Дата
Msg-id stfgfcd1sm7oi9tvga0kg9kaj1069q3cvb@4ax.com
обсуждение исходный текст
Ответ на [GENERAL] full text search on hstore or json with materialized view?  (Rj Ewing <ewing.rj@gmail.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: George Neuner
Дата:
Сообщение: Re: [GENERAL] full text search on hstore or json with materialized view?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] referential integrity between elements of an array and another table?