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 <[email protected]>: >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 ><[email protected] >> 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 < >> [email protected]>: >> > >> >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. >> > > > >-- >Wells Oliver >[email protected] <[email protected]> -- Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
