how to generate a list of distinct scalar values from a column which type is array

Поиск
Список
Период
Сортировка
От Sergio Andreozzi
Тема how to generate a list of distinct scalar values from a column which type is array
Дата
Msg-id 2cfc7c940702211021u1ba47031l25112a69cfb18338@mail.gmail.com
обсуждение исходный текст
Ответы Re: how to generate a list of distinct scalar values from a column which type is array  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: how to generate a list of distinct scalar values from a column which type is array  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-sql
Dear all, <br /><br />given a column which type is for instance varchar(20)[], is there any SQL command that let me
generatethe list of distinct scalar values? <br /><br /><br />e.g.: <br />             col1<br />row 1: (aaa, bb, c)
<br/>row 2: (dddd, eeee) <br />row 3: (aaa, eeee) <br /><br />the query should return: <br /><br />aaa <br />bb <br />c
<br/>dddd <br />eeee <br /><br />if not, I guess the approach is to use stored procedure. Any code
snippet/suggestion?<br/><br />Thanks, Sergio <br /><br /> 

В списке pgsql-sql по дате отправления:

Предыдущее
От: "devil live"
Дата:
Сообщение: Re: Problem with Temp Table and Result Set from PL Function...
Следующее
От: Martin Marques
Дата:
Сообщение: Problems with temp table and PL