Revision 7361
Added by ben leinfelder over 12 years ago
src/doi_registration.sql | ||
---|---|---|
103 | 103 |
|
104 | 104 |
-- add the first name if we have it |
105 | 105 |
update doi_registration doi |
106 |
set publisher = child.nodedata ||' '|| creator
|
|
106 |
set publisher = publisher ||', '|| child.nodedata
|
|
107 | 107 |
from identifier id, |
108 | 108 |
xml_documents docs, |
109 | 109 |
xml_nodes nodes, |
... | ... | |
161 | 161 |
|
162 | 162 |
-- add the first name if we have it |
163 | 163 |
update doi_registration doi |
164 |
set creator = child.nodedata ||' '|| creator
|
|
164 |
set creator = creator ||', '|| child.nodedata
|
|
165 | 165 |
from identifier id, |
166 | 166 |
xml_documents docs, |
167 | 167 |
xml_nodes nodes, |
... | ... | |
243 | 243 |
|
244 | 244 |
--include the first name (careful not to rerun this part) |
245 | 245 |
update doi_registration doi |
246 |
set publisher = child.nodedata ||' '|| publisher
|
|
246 |
set publisher = publisher ||', '|| child.nodedata
|
|
247 | 247 |
from identifier id, |
248 | 248 |
xml_revisions docs, |
249 | 249 |
xml_nodes_revisions nodes, |
... | ... | |
299 | 299 |
|
300 | 300 |
-- add the first name if we have it |
301 | 301 |
update doi_registration doi |
302 |
set creator = child.nodedata ||' '|| creator
|
|
302 |
set creator = creator ||', '|| child.nodedata
|
|
303 | 303 |
from identifier id, |
304 | 304 |
xml_revisions docs, |
305 | 305 |
xml_nodes_revisions nodes, |
... | ... | |
568 | 568 |
case when givenName is null then |
569 | 569 |
sn |
570 | 570 |
else |
571 |
givenName|| ' ' || sn
|
|
571 |
sn || ', ' || givenName
|
|
572 | 572 |
end |
573 | 573 |
from ecoinfo_dn |
574 | 574 |
where trim(both from lower(creator)) = lower(dn); |
... | ... | |
578 | 578 |
case when givenName is null then |
579 | 579 |
sn |
580 | 580 |
else |
581 |
givenName|| ' ' || sn
|
|
581 |
sn || ', ' || givenName
|
|
582 | 582 |
end |
583 | 583 |
from ecoinfo_dn |
584 | 584 |
where trim(both from lower(publisher)) = lower(dn); |
Also available in: Unified diff
use "lastname, firstname" convention throughout