| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)pl> |
|---|---|
| To: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
| Cc: | Adam Haberlach <adam(at)newsnipple(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: UNION within VIEW workarounds? |
| Date: | 2000-12-08 09:26:32 |
| Message-ID: | 20001208102632.A28802@gruby |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Dec 07, 2000 at 07:45:02PM -0600, Ed Loehr wrote:
> One advantage is that you can hide internal db schema from applications
> that may need to access your db. That frees you to change the internal
> schema somewhat as long as you honor the agreed "interface" of the
> view...
another advantage is that at some point of time when you need greater
performance on select's you can change your views to physical tables
regenerated from time to time.
depesz
--
hubert depesz lubaczewski
------------------------------------------------------------------------
najwspanialszą rzeczą jaką dało nam nowoczesne społeczeństwo,
jest niesamowita wręcz łatwość unikania kontaktów z nim ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Denis Perchine | 2000-12-08 10:01:48 | My patches are now on a webpage. |
| Previous Message | Juriy Goloveshkin | 2000-12-08 07:38:33 | ilike and --enable-multibyte=KOI8 |