How can I count unique values from a string_agg query?

[4StarGen]

I'm trying to compress the output of a string counting only the unique values in it, how can I do it?

Code: Select all

(string_agg(CASE
               WHEN expression
                  THEN some string
               ELSE NULL
               END, ',' ORDER BY cash_hand_player_statistics.date_played DESC))

[Flag_Hippo]

I'm afraid I don't know or have any SQL for that but if I am able to find out anything further I will let you know.

[Flag_Hippo]

Can you please post in more detail exactly what you are trying actually to achieve with this.

[4StarGen]

it is solved already