Metacat

-- add the first name if we have it

update doi_registration doi

from identifier id, 

xml_documents docs, 

xml_nodes nodes, 

-- add the first name if we have it

update doi_registration doi

from identifier id, 

xml_documents docs, 

xml_nodes nodes, 

--include the first name (careful not to rerun this part)

update doi_registration doi

from identifier id, 

xml_revisions docs, 

xml_nodes_revisions nodes, 

-- add the first name if we have it

update doi_registration doi

from identifier id, 

xml_revisions docs, 

xml_nodes_revisions nodes, 

case when givenName is null then

	sn

else 

end

from ecoinfo_dn

where trim(both from lower(creator)) = lower(dn);

case when givenName is null then

	sn

else 

end

from ecoinfo_dn

where trim(both from lower(publisher)) = lower(dn);