Dear all,
given a column which type is for instance varchar(20)[], is there any SQL
command that let me generate the list of distinct scalar values?
e.g.:
col1
row 1: (aaa, bb, c)
row 2: (dddd, eeee)
row 3: (aaa, eeee)
the query should return:
aaa
bb
c
dddd
eeee
if not, I guess the approach is to use stored procedure. Any code
snippet/suggestion?
Thanks, Sergio