Re: benefits of an Array Column? - Mailing list pgsql-novice

From Joe Conway
Subject Re: benefits of an Array Column?
Date
Msg-id 40D5E5AA.8030706@joeconway.com
Whole thread Raw
In response to Re: benefits of an Array Column?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: benefits of an Array Column?
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: benefits of an Array Column?
Next
From:
Date:
Subject: Re: libpq.so