Time penalty on VIEWS on VIEWS

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: Time penalty on VIEWS on VIEWS
Date: 2000-11-05 11:48:59
Message-ID: 20001105124859.C27532@gruby
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

My situation: VIEW A is grouping information from 2 tables (B,C). I have to
make another VIEW with additional WHERE statement compared in VIEW A. I can
make this as a VIEW groupping tables B and C, or makeing VIEW of VIEW A.
I know that second sollution is more flexible but there should be some kind of
time penalty. I'm wondering how much it is.

regards,

depesz

--
hubert depesz lubaczewski
------------------------------------------------------------------------
najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...

Browse pgsql-general by date

  From Date Subject
Next Message Jesus Aneiros 2000-11-05 14:44:27 Re: [NOVICE] Help needed with pg.pm to connect to postgresql
Previous Message hubert depesz lubaczewski 2000-11-05 11:42:04 Question about ordering views