Re: Critique needed for contact-DB draft

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Felix E(dot) Klee" <felix(dot)klee(at)inka(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Critique needed for contact-DB draft
Date: 2004-07-15 04:35:55
Message-ID: 20040715043555.GA11252@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Jul 15, 2004 at 02:27:37 +0200,
"Felix E. Klee" <felix(dot)klee(at)inka(dot)de> wrote:
>
> I'm especially interested on your take of my use of arrays. They avoid
> the need for additional tables, but maybe they are not good,
> nevertheless?
>
> BTW, what I'm really missing is as a newbie is a way to define new data
> types as "structures" as known from e.g. the C programming language (or
> is this supported by PostgreSQL?). That would IMHO be a more natural
> concept for storing data (for example, then I could create an array of
> addresses for each contact).

You don't want to do that. You want to have a person table and a table
that contains a record for each contact address combination. Depending
on how you are using the addresses you might also want a separate address
table.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2004-07-15 05:30:26 Re: Critique needed for contact-DB draft
Previous Message Mark Dexter 2004-07-15 01:21:57 Calling Functions and Stored Procedures