From: | "Andrew L(dot) Gould" <algould(at)datawok(dot)com> |
---|---|
To: | elein <elein(at)varlena(dot)com>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
Cc: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Arrays and "goodness" in RDBMSs (was Re: join of |
Date: | 2003-08-15 20:36:15 |
Message-ID: | 200308151536.15177.algould@datawok.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-patches |
On Friday 15 August 2003 02:56 pm, elein wrote:
> In response to both Andrew Gould and Ron Johnson...
>
> If arrays are not natural in the organization of
> your data, don't use them. That is the guideline.
>
> If the array defines something specific they are
> very natural. The confusion could be that arrays
> are abstract types.
>
> Specific implementations which use arrays might
> be clearer. For example, a definition of a polygon
> is an array of Points. Points, themselves are an
> array.
>
> (The actual postgreSQL implementation of polygons and points
> doesn't use the newer cleaner array abstraction, I think.
> But if I were reimplementing them, I would build on
> top of the new array capabilities. The point is to show
> an array structured object which makes sense in context.)
>
> Of course you can denomalize via arrays, but it tends
> to make things harder for you. And I believe the
> same thing is true for denormalized integer columns.
>
> elein
> =============================================================
> elein(at)varlena(dot)com www.varlena.com
Thanks, Elein. The polygon example makes it clearer. In the books I have
here, the examples show how to use arrays but they use data that I would move
to another table.
Best regards,
Andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Parker | 2003-08-15 20:51:44 | Re: New to list, quick question. |
Previous Message | elein | 2003-08-15 19:56:33 | Re: Arrays and "goodness" in RDBMSs (was Re: join of |
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2003-08-15 22:24:02 | Re: Arrays and "goodness" in RDBMSs (was Re: join of |
Previous Message | elein | 2003-08-15 19:56:33 | Re: Arrays and "goodness" in RDBMSs (was Re: join of |