1 -- Fix sorting by pubdate by ensuring migrated records
2 -- have a pubdate attribute in metabib.record_attr.attrs
3 UPDATE metabib.record_attr
4 SET attrs = attrs || ('pubdate' => (attrs->'date1'))
5 WHERE defined(attrs, 'pubdate') IS FALSE
6 AND defined(attrs, 'date1') IS TRUE;