Re: Options for complex materialized views sharing most of the same logic?

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Options for complex materialized views sharing most of the same logic?
Дата
Msg-id EDB8C028-9DD3-4733-A67B-3B447267BCD8@a-kretschmer.de
обсуждение исходный текст
Ответ на Re: Options for complex materialized views sharing most of the same logic?  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-general
Дерево обсуждения
Maybe you can create a so called SRF - Funktion (Set Returning Funktion) with proper parameters to use AS 'create materialized view ... AS select * Form your_srf_Funktion(param1,param2,...,paramN). Untested, but i think it should work.


(stupid smartphone-app ...)

Am 27. Dezember 2015 23:04:07 MEZ, schrieb Wells Oliver <wells.oliver@gmail.com>:
I do not. I just probably tweak it a couple of times a week due to adding/removal of columns of interest and I just would like to have the logic in one place if possible...

On Sun, Dec 27, 2015 at 4:03 PM, Andreas Kretschmer <andreas@a-kretschmer.de> wrote:
Do you recreate the views every day? Why?

(stupid smartphone-app, sorry for top-posting)

Am 27. Dezember 2015 22:39:58 MEZ, schrieb Wells Oliver <wells.oliver@gmail.com>:
>
>Is there some easier way for me to maintain the structure of the view
>without copying/pasting it 4 times and making one small tweak? I find
>myself adding/removing columns to these views and I do it 4 times

--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.



--

--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.

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

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Re: Options for complex materialized views sharing most of the same logic?
Следующее
От: Hiroyuki Sato
Дата:
Сообщение: Re: grep -f keyword data query