Design Question

Поиск
Список
Период
Сортировка
От Andy Lewis
Тема Design Question
Дата
Msg-id Pine.LNX.4.05.9911271221150.8115-100000@rns.roundnoon.com
обсуждение исходный текст
Ответы Re: [SQL] Design Question
Re: [SQL] Design Question
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] Usage of index in "ORDER BY" operations
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: [SQL] Design Question