...
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.
...
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'
...
)
...
select
...
...
...
lc.instance_hrid,
...
...
...
lc.field,
...
...
...
...
...
string_agg
...
(lc.content,
...
'
...
--
...
')
...
as
...
lc_subject
...
from lc
...
group by
...
...
...
lc.instance_hrid,
...
...
...
lc.field
;
ORDER BY
;
And the results would be:
...