category-synonyms-procs.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>

  <fullquery name="category_synonym::search_sweeper.delete_old_searches">
    <querytext>
      delete from category_search
      where last_queried < current_timestamp - interval '1' day
    </querytext>
  </fullquery>

</queryset>