Re: UNION within VIEW workarounds?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: UNION within VIEW workarounds?
Дата
Msg-id 20001208102632.A28802@gruby
обсуждение исходный текст
Ответ на Re: UNION within VIEW workarounds?  (Ed Loehr <eloehr@austin.rr.com>)
Список 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 ...

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

Предыдущее
От: Andrew Nosenko
Дата:
Сообщение: Re: Oracle-compatible lpad/rpad behavior
Следующее
От: Denis Perchine
Дата:
Сообщение: My patches are now on a webpage.