Limit for number of Joins in a View? Version 8.1.4 on Redhat 9

Поиск
Список
Период
Сортировка
От MargaretGillon@chromalloy.com
Тема Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
Дата
Msg-id OF996DDA3D.53730166-ON8825727A.00800666-8825727A.0080F55B@CHROMALLOY.COM
обсуждение исходный текст
Ответы Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Дерево обсуждения

I am wondering what the limit is on the number of joins in a View or a Select.

Background: I have many tables with similar flags such as Active, Inactive, High, Medium, Low. I am storing the flags in a flag table and then putting an int4 foreign key to the flag in the data tables. Some data tables may have up to 15 flags, as well as 30 or 40 other foreign keys. They're all left outer joins. Is this a problem for a view?

*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los Angeles, ext. 297

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

Предыдущее
От: Rafael Alves
Дата:
Сообщение: leaving this group
Следующее
От: Jeff Amiel
Дата:
Сообщение: Re: pg_dump/restore and functions/triggers/trigger functions