quick_customer_search_view.sql

quick_customer_search_view.sql

-- build a view to show all data that combines
create view quick_customer_search as
   select customer_search.*
   from customer_search
   -- * records that are not marked as stale
   where customer_search.is_stale = false
   union all
   select r.*
   from customer_search
       -- * records that are stale => recompute the most up to date fields on the fly
       cross join refresh_customer_search (customer_search.customer_id, customer_search.contact_id) r
   where customer_search.is_stale = true;