Re: benefits of an Array Column?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: jarednevans(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: benefits of an Array Column?
Date: 2004-06-20 19:29:46
Message-ID: 40D5E5AA.8030706@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Tom Lane wrote:
> jarednevans(at)yahoo(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ghaverla 2004-06-20 23:08:22 Re: libpq.so
Previous Message Tom Lane 2004-06-20 19:03:12 Re: benefits of an Array Column?