On Jun 5, 12:13 pm, [EMAIL PROTECTED] (Kristo Kaiv) wrote:
> 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
Great !!!
Many thanks Kristo, it's just what I need
Guy
Kristo Kaiv a écrit :
> 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');
>
>
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_upp
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 c
