Received: from mail.vicnet.net.au (merri.vicnet.net.au [203.10.72.9]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA79860 for ; Sat, 27 Nov 1999 17:50:38 -0500 (EST) (envelope-from julienc@vicnet.net.au) Received: from jcadiou (dhcp76-72.slv.vic.gov.au [202.137.76.72]) by mail.vicnet.net.au (Postfix) with SMTP id 72350F8130; Sun, 28 Nov 1999 09:50:33 +1100 (EST) Message-Id: <3.0.3.32.19991128095033.0155db00@mail.vicnet.net.au> X-Sender: julienc@mail.vicnet.net.au X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.3 (32) Date: Sun, 28 Nov 1999 09:50:33 +1100 To: Andy Lewis From: Julien Cadiou Subject: Re: [SQL] Design Question Cc: pgsql-sql@postgreSQL.org In-Reply-To: Mime-Version: 1.0 Content-Type: text/enriched; charset="us-ascii" 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 > > >************ > > > Julien CADIOU Database Administrator VICNET - Victoria's network Phone: (03) 9669 9710 Fax: (03) 9669 9805 Web: http://www.vicnet.net.au/