[[#variable1cedd360]] + [[#variable1cede140]] + [[#variable1cedd3c0]] + "FROM information_schema.triggers t, " + "(select trigger_schema, " + " trigger_name, " + " rtrim( " + " max(case when pos=0 then manip else \'\' end)|| " + " max(case when pos=1 then manip else \'\' end)|| " + " max(case when pos=2 then manip else \'\' end), \' or \' " + " ) as manip " + "from ( " + " select a.trigger_schema, " + " a.trigger_name, " + " a.event_manipulation||\' or \' as manip, " + " d.cnt, " + " a.rnk as pos " + " from ( select trigger_name, " + " trigger_schema, " + " event_manipulation, " + " (select count(distinct is1.event_manipulation) " + " from information_schema.triggers is1 " + " where is2.event_manipulation < is1.event_manipulation) as rnk " + " from information_schema.triggers is2 " + " ) a, " + " (select trigger_schema, trigger_name, count(event_manipulation) as cnt " + " from ( " + " select trigger_schema, " + " trigger_name, " + " event_manipulation, " + " (select count(distinct is3.event_manipulation) " + " from information_schema.triggers is3 " + " where is4.event_manipulation < is3.event_manipulation) as rnk " + " from information_schema.triggers is4 " + " ) y " + " group by trigger_schema, trigger_name) d " + " where d.trigger_name = a.trigger_name " + " and d.trigger_schema = a.trigger_schema " + ") x " + "group by trigger_schema, trigger_name " + "order by 1) v " + "where t.trigger_schema = v.trigger_schema " + "and t.trigger_name = v.trigger_name " + "and t.trigger_schema = ? " + "and t.trigger_name = ? "
|