3 SELECT evergreen.upgrade_deps_block_check('1278', :eg_version);
5 CREATE OR REPLACE VIEW reporter.asset_call_number_dewey AS
6 SELECT id AS call_number,
7 call_number_dewey(label) AS dewey,
8 CASE WHEN call_number_dewey(label) ~ '^[0-9]+\.?[0-9]*$'::text
9 THEN btrim(to_char(10::double precision * floor(call_number_dewey(label)::double precision / 10::double precision), '000'::text))
11 END AS dewey_block_tens,
12 CASE WHEN call_number_dewey(label) ~ '^[0-9]+\.?[0-9]*$'::text
13 THEN btrim(to_char(100::double precision * floor(call_number_dewey(label)::double precision / 100::double precision), '000'::text))
15 END AS dewey_block_hundreds,
16 CASE WHEN call_number_dewey(label) ~ '^[0-9]+\.?[0-9]*$'::text
17 THEN (btrim(to_char(10::double precision * floor(call_number_dewey(label)::double precision / 10::double precision), '000'::text)) || '-'::text)
18 || btrim(to_char(10::double precision * floor(call_number_dewey(label)::double precision / 10::double precision) + 9::double precision, '000'::text))
20 END AS dewey_range_tens,
21 CASE WHEN call_number_dewey(label) ~ '^[0-9]+\.?[0-9]*$'::text
22 THEN (btrim(to_char(100::double precision * floor(call_number_dewey(label)::double precision / 100::double precision), '000'::text)) || '-'::text)
23 || btrim(to_char(100::double precision * floor(call_number_dewey(label)::double precision / 100::double precision) + 99::double precision, '000'::text))
25 END AS dewey_range_hundreds
26 FROM asset.call_number
27 WHERE call_number_dewey(label) ~ '^[0-9]'::text;