Re: [SQL] Design Question

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/