Re: benefits of an Array Column?

Is there not a speed advantage using arrays in the right place instead
of tables ?
János
On Jun 20, 2004, at 3:29 PM, Joe Conway wrote:

> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>
------------------------------------------
"The shortest route between two points is the middleman"  Ayn Rand