Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group