Page History

...

Further, if you want to display the subject heading as it appears in the bibliographic record, you may use a STRING_AGG FUNCTION to format the content rows as a subject heading string. Here is an example using instance HRIDs between 6403921 and 6404000:

WITH lc as

(SELECT DISTINCT
        sm.instance_hrid,
        sm.field,
        sm.

...

ORDER BY

...

content

FROM srs_marctab sm

WHERE sm.instance_hrid between '6403921' and '6404000'
        AND sm.field like '6%%'
        AND sm.sf in ('a','x','y','z')
        AND sm.ind2 = '0'
        AND sm.ord = '1'

...

sm.sf

)

SELECT
        lc.instance_hrid,
        lc.field,

lc.sf

        string_agg (lc.content, ' -- ') as lc_subject

FROM lc

GROUP BY
        lc.instance_hrid,
        lc.field

ORDER BY

;


And the results would be:

Image Added