X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/58e057254087f406ca4146da7031187487b0ddbc..c1298836a79c1f3734c95f87f11615daf70806e3:/services/api/db/structure.sql diff --git a/services/api/db/structure.sql b/services/api/db/structure.sql index 59af57f75c..24c5ba3e46 100644 --- a/services/api/db/structure.sql +++ b/services/api/db/structure.sql @@ -255,6 +255,24 @@ select upd_container_uuid, upd_priority from tab; $$; +-- +-- Name: jsonb_exists_all_inline_op(jsonb, text[]); Type: FUNCTION; Schema: public; Owner: - +-- + +CREATE FUNCTION public.jsonb_exists_all_inline_op(jsonb, text[]) RETURNS boolean + LANGUAGE sql IMMUTABLE + AS $_$SELECT $1 ?& $2$_$; + + +-- +-- Name: jsonb_exists_inline_op(jsonb, text); Type: FUNCTION; Schema: public; Owner: - +-- + +CREATE FUNCTION public.jsonb_exists_inline_op(jsonb, text) RETURNS boolean + LANGUAGE sql IMMUTABLE + AS $_$SELECT $1 ? $2$_$; + + -- -- Name: project_subtree_with_is_frozen(character varying, boolean); Type: FUNCTION; Schema: public; Owner: - -- @@ -3270,6 +3288,7 @@ INSERT INTO "schema_migrations" (version) VALUES ('20221219165512'), ('20221230155924'), ('20230421142716'), -('20230503224107'); +('20230503224107'), +('20230815160000');