Design Question

From: Andy Lewis <alewis(at)roundnoon(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Design Question
Date: 1999-11-27 18:25:55
Message-ID: Pine.LNX.4.05.9911271221150.8115-100000@rns.roundnoon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rich Shepard 1999-11-27 18:41:42 Re: [SQL] Design Question
Previous Message Tom Lane 1999-11-27 17:18:02 Re: [SQL] Usage of index in "ORDER BY" operations