issue with string_agg with distinct in postgres

select string_agg(distinct 'pre' || user.col, 'post')

As the above will deny the use of an index in the distinct aggregation take the 'pre' out

select 'pre' || string_agg(distinct user.col, 'postpre')