Re: How to count the number of items in an Array?

One more time, thanks for the reply. I'am using postgre 8.3. I think I don't
have the array_agg(), there is another way of doing it?

Best Regards,

On Sun, Feb 21, 2010 at 2:46 PM, Andreas Kretschmer <
akretschmer(at)spamfence(dot)net> wrote:

> Andre Lopes <lopes80andre(at)gmail(dot)com> wrote:
>
> > Hi,
> >
> > Thanks for the reply.
> >
> > My problem is that I can't have the array with all items. I need to read
> from a
> > table and store in an Array the values.
>
> Not sure if i understand you, but how about:
>
> test=*# select * from foo;
> a
> ---
> 1
> 3
> 5
> 7
> (4 Zeilen)
>
> Zeit: 0,203 ms
> test=*# select array_agg(a) from foo;
> array_agg
> -----------
> {1,3,5,7}
> (1 Zeile)
>
>
> The function returns a column as an array.
>
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect. (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly." (unknown)
> Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>