Page History

...

WITH lc as
(SELECT DISTINCT
sm.instance_hrid,
sm.field,

sm.sf,
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'

ORDER BY

sm.instance.hrid,

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:

...