Re: [SQL] Design Question

From: Julien Cadiou <julienc(at)vicnet(dot)net(dot)au>
To: Andy Lewis <alewis(at)roundnoon(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Design Question
Date: 1999-11-27 22:50:33
Message-ID: 3.0.3.32.19991128095033.0155db00@mail.vicnet.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Andy,

actually, the postgres site has pretty much what you're after I think.

If you go under documentation, and going through the "tutorial", the example they use is quite similar (if I remember correctly) to what you're after ...

Cheers,

At 12:25 27/11/1999 -0600, you wrote:

>Hello All!

>

>Lets say that I have a DB that I am using to save address info on

>different brokers. Broker name, address, city, state, zip

>

>Some brokers have representation in different states.

>

>How would I be able to save that info so that it can be later selected by

>users looking for a broker in a certain state(s)?

>

>What type of field/table/DB could I save that in for easy reference?

>

>Thanks!

>

>Andy

>

>

>************

>

>

>

<bold>Julien CADIOU

</bold>Database Administrator

<bold>VICNET</bold> - Victoria's network

Phone: (03) 9669 9710

Fax: (03) 9669 9805

Web: http://www.vicnet.net.au/

Attachment Content-Type Size
unknown_filename text/enriched 925 bytes

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Julien Cadiou 1999-11-27 23:00:41 recusrion
Previous Message Andy Lewis 1999-11-27 18:49:10 Re: [SQL] Design Question