Postgres Pro
Downloads
Home   >   mailing lists

Limit for number of Joins in a View? Version 8.1.4 on Redhat 9 - Mailing list pgsql-general

From MargaretGillon@chromalloy.com
Subject Limit for number of Joins in a View? Version 8.1.4 on Redhat 9
Date
Msg-id OF996DDA3D.53730166-ON8825727A.00800666-8825727A.0080F55B@CHROMALLOY.COM
Whole thread Raw
Responses Re: Limit for number of Joins in a View? Version 8.1.4 on Redhat 9  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view

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 by date:

Previous
From: Rafael Alves
Date:
Subject: leaving this group
Next
From: Jeff Amiel
Date:
Subject: Re: pg_dump/restore and functions/triggers/trigger functions