Re: get the array content whis the select clause

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