public.swh_skipped_content_missing.sql
No OneTemporary
Actions

Size

982 B

Subscribers

None

public.swh_skipped_content_missing.sql
View Options

	--
	-- PostgreSQL database dump
	--

	-- Dumped from database version 10.1
	-- Dumped by pg_dump version 10.2 (Debian 10.2-1.pgdg+1)

	SET statement_timeout = 0;
	SET lock_timeout = 0;
	SET idle_in_transaction_session_timeout = 0;
	SET client_encoding = 'UTF8';
	SET standard_conforming_strings = on;
	SET check_function_bodies = false;
	SET client_min_messages = warning;
	SET row_security = off;

	SET search_path = public, pg_catalog;

	--
	-- Name: swh_skipped_content_missing(); Type: FUNCTION; Schema: public; Owner: -
	--

	CREATE FUNCTION swh_skipped_content_missing() RETURNS SETOF content_signature
	LANGUAGE plpgsql
	AS $$
	begin
	return query
	select sha1, sha1_git, sha256, blake2s256 from tmp_skipped_content t
	where not exists
	(select 1 from skipped_content s where
	s.sha1 is not distinct from t.sha1 and
	s.sha1_git is not distinct from t.sha1_git and
	s.sha256 is not distinct from t.sha256);
	return;
	end
	$$;


	--
	-- PostgreSQL database dump complete
	--