Dobrica Pavlinušić's random unstructured stuff

eprints: Revision 2

Documents with departments and security settings

.pre
select
archive.eprintid,department,security
from archive,document
where document.eprintid = archive.eprintid and department like '%informacijske%';
.pre

Update access to `staffonly`

.pre
begin;
update document set security='staffonly' where eprintid in ( select eprintid from archive where department like '%informacijske%' );
commit;
.pre