- args:
    cascade: true
    sql: "CREATE FUNCTION search_jobs(search text)\r\nRETURNS SETOF jobs AS $$\r\n
      \   SELECT *\r\n    FROM jobs\r\n    WHERE\r\n      ownr_fn ilike ('%' || search
      || '%')\r\n      OR ownr_ln ilike ('%' || search || '%')\r\n      OR ro_number
      ilike ('%' || search || '%')\r\n      OR est_number ilike ('%' || search ||
      '%')\r\n      OR clm_no ilike ('%' || search || '%')\r\n      OR ownr_ph1 ilike
      ('%' || search || '%')\r\n      OR ownr_ea ilike ('%' || search || '%')\r\n
      \     OR insd_ln ilike ('%' || search || '%')\r\n      OR insd_fn ilike ('%'
      || search || '%')\r\n$$ LANGUAGE sql STABLE;\r\n"
  type: run_sql
- args:
    name: search_jobs
    schema: public
  type: track_function
