Re: faster way to calculate top "tags" for a "resource" based on a column

Поиск
Список
Период
Сортировка
От Jonathan Vanasco
Тема Re: faster way to calculate top "tags" for a "resource" based on a column
Дата
Msg-id 9CCEB3B9-F024-4860-B97D-A453887F1A07@2xlp.com
обсуждение исходный текст
Ответ на Re: faster way to calculate top "tags" for a "resource" based on a column  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-general
On Oct 6, 2014, at 5:56 PM, Jim Nasby wrote:

> Don't join to the resource table; there's no reason to because you're not pulling anything from it.

Thanks the reply!

I'm not pulling anything from the resource table, but the join is necessary because I'm filtering based on it. ( see
theWHERE clause ) 

I'm not trying to find the most used overall tags, but the ones that are used by resources with a (variable) id on a
columnin the resources table. .   



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

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: Converting char to varchar automatically
Следующее
От: Gavin Flower
Дата:
Сообщение: Re: table versioning approach (not auditing)