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