Metacat

-- set the publisher to the source system if it is the same as the creator

update doi_registration

set publisher = 

case 

when guid like 'doi:10.5063%' then

	'Knowledge Network for Biocomplexity (KNB)'

when guid like 'doi:10.6085%' then

	'Partnership for Interdisciplinary Studies of Coastal Oceans (PISCO)'

when guid like 'doi:10.6073%' then

	'Long Term Ecological Research Network (LTER)'

else

	publisher

end

where publisher = creator;