Re: benefits of an Array Column?

Tom Lane wrote:
> jarednevans@yahoo.com writes:
>>I fail to see the scenarios where this would be an useful feature.  How
>>is this better than linking to another table that could serve the same
>>purpose?

> I think probably the rule of thumb is that arrays work when you have
> data items that have an array-like structure, but that substructure
> isn't interesting from the standpoint of the database structure.

I agree, but would add that arrays are often very useful as
non-persistent structures for processing data, e.g. in PL/pgSQL functions.

Joe