Re: an aggregate array function

It's in the SQL99 standard. There's nothing forcing you to use them - I 
am a (possibly) old-fashioned data architect, so I never use them ;-)

SQL99 actually allows you to use more or less arbitrary composite types 
as columns (although Pg currently doesn't) - many would argue that this 
violates first normal form. OTOH there's probably a good case to make 
that all this is necessary to provide good support to ObjectRelational 
mappings, and other OO stuff.

andrew

Dani Oderbolz wrote:

> I got another question to this:
> why does PostgreSQL support Arrays in the first place?
> For my taste, its a very messy concept...
>
> Regards,
> Dani
>
>