Re: Queries joining views

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Queries joining views
Дата
Msg-id 2446.1156252906@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Queries joining views  (Alban Hertroys <alban@magproductions.nl>)
Ответы Re: Queries joining views  (Alban Hertroys <alban@magproductions.nl>)
Список pgsql-general
Alban Hertroys <alban@magproductions.nl> writes:
> However, mm_product.number always matches either mm_insrel.snumber or
> mm_insrel.dnumber (source and destination respectively). The other way
> around this isn't the case; then snumber and dnumber match number-fields
> in other tables (they always do).

Oh, then we are looking at the wrong things: we should be comparing the
histograms of the fields that are being used as the join keys in this
query.  I had thought they were both "number", but I must be confused.

            regards, tom lane

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Queries joining views
Следующее
От: "Silvela, Jaime \(Exchange\)"
Дата:
Сообщение: Re: could not open relation - why?