-- 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 $$;