Lucas Nussbaum wrote: > I removed that view because... > ,,,it was a bit painful to update when the sources > schema changed. > > It was defined as the equivalent of: > SELECT * FROM sources -- that's Debian's source packages > UNION SELECT * FROM ubuntu_sources -- that's Ubuntu's > UNION SELECT * FROM derivatives_sources;
if all these tables have "sources" as final part of their names and there are not any other tables with this feature, then probably you can make a dynamic query and execute it on runtime. open a cursor on select "select * from " || table_name from $TableCatalog where table_name like "%sources" take each result and add " union all " at the end it this is not the last execute immediate (or similar command) for executing the query in the string you have created. Ciao Davide -- La mia privacy non รจ affar tuo https://noyb.eu/it - You do not have my permission to use this email to train an AI - If you use this to train your AI than you accept to distribute under AGPL license >= 3.0 all the model trained, all the source you have used to training your model and all the source of the program that use that model
