Re: get the array content whis the select clause

Поиск
Список
Период
Сортировка
От Kristo Kaiv
Тема Re: get the array content whis the select clause
Дата
Msg-id DFF9CC68-0B19-4464-B998-626911BF4360@skype.net
обсуждение исходный текст
Ответ на get the array content whis the select clause  (De Leeuw Guy <G.De_Leeuw@eurofer.be>)
Ответы Re: get the array content whis the select clause  (De Leeuw Guy <G.De_Leeuw@eurofer.be>)
Re: get the array content whis the select clause  (Erwin Brandstetter <brsaweda@gmail.com>)
Список pgsql-admin
i guess this what you meant:
(not a nice solution though) writing a function that returns the set
would be a better idea

create table testintarr (iarr int[]);
insert into testintarr values ('5,6,7,8');

test=# select iarr[idx] from (select iarr, generate_series(array_lower
(iarr,1), array_upper(iarr,1)) as idx from testintarr) asdf;
iarr
------
     5
     6
     7
     8
(4 rows)

BR,
Kristo

On 04.06.2007, at 23:47, De Leeuw Guy wrote:

> Hello all
>
> It is possible to return the content of an int array [] with a select
> clause ?
>
> Thanks in advance for your respons
>
> Guy
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that
> your
>        message can get through to the mailing list cleanly


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Auto Vacuum question?
Следующее
От: Brad Nicholson
Дата:
Сообщение: Re: the right time to vacuum database?