041.sql
No OneTemporary
Actions

Size

542 B

Subscribers

None

041.sql
View Options

	-- SWH DB schema upgrade
	-- from_version: 40
	-- to_version: 41
	-- description: Open directory get by id

	insert into dbversion(version, release, description)
	values(41, now(), 'Work In Progress');

	-- Retrieve information on directory from temporary table
	create or replace function swh_directory_get()
	returns setof directory
	language plpgsql
	as $$
	begin
	return query
	select d.id, d.dir_entries, d.file_entries, d.rev_entries
	from tmp_directory t
	inner join directory d on t.id = d.id;
	return;
	end
	$$;