asset_call_number_dewey

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

call_number

int8

19

√

null

dewey

text

2147483647

√

null

dewey_block_tens

text

2147483647

√

null

dewey_block_hundreds

text

2147483647

√

null

dewey_range_tens

text

2147483647

√

null

dewey_range_hundreds

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT call_number.id AS call_number,
    call_number_dewey(call_number.label) AS dewey,
        CASE
            WHEN (call_number_dewey(call_number.label) ~ '^[0-9]+\.?[0-9]*$'::text) THEN btrim(to_char(((10)::double precision * floor(((call_number_dewey(call_number.label))::double precision / (10)::double precision))), '000'::text))
            ELSE NULL::text
        END AS dewey_block_tens,
        CASE
            WHEN (call_number_dewey(call_number.label) ~ '^[0-9]+\.?[0-9]*$'::text) THEN btrim(to_char(((100)::double precision * floor(((call_number_dewey(call_number.label))::double precision / (100)::double precision))), '000'::text))
            ELSE NULL::text
        END AS dewey_block_hundreds,
        CASE
            WHEN (call_number_dewey(call_number.label) ~ '^[0-9]+\.?[0-9]*$'::text) THEN ((btrim(to_char(((10)::double precision * floor(((call_number_dewey(call_number.label))::double precision / (10)::double precision))), '000'::text)) || '-'::text) || btrim(to_char((((10)::double precision * floor(((call_number_dewey(call_number.label))::double precision / (10)::double precision))) + (9)::double precision), '000'::text)))
            ELSE NULL::text
        END AS dewey_range_tens,
        CASE
            WHEN (call_number_dewey(call_number.label) ~ '^[0-9]+\.?[0-9]*$'::text) THEN ((btrim(to_char(((100)::double precision * floor(((call_number_dewey(call_number.label))::double precision / (100)::double precision))), '000'::text)) || '-'::text) || btrim(to_char((((100)::double precision * floor(((call_number_dewey(call_number.label))::double precision / (100)::double precision))) + (99)::double precision), '000'::text)))
            ELSE NULL::text
        END AS dewey_range_hundreds
   FROM asset.call_number
  WHERE (call_number_dewey(call_number.label) ~ '^[0-9]'::text);

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views