Design Question - Mailing list pgsql-sql

From Andy Lewis
Subject Design Question
Date
Msg-id Pine.LNX.4.05.9911271221150.8115-100000@rns.roundnoon.com
Whole thread Raw
Responses Re: [SQL] Design Question  (Rich Shepard <rshepard@appl-ecosys.com>)
Re: [SQL] Design Question  (Julien Cadiou <julienc@vicnet.net.au>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Usage of index in "ORDER BY" operations
Next
From: Rich Shepard
Date:
Subject: Re: [SQL] Design Question