Re: [SQL] Design Question - Mailing list pgsql-sql

From Julien Cadiou
Subject Re: [SQL] Design Question
Date
Msg-id 3.0.3.32.19991128095033.0155db00@mail.vicnet.net.au
Whole thread Raw
In response to Design Question  (Andy Lewis <alewis@roundnoon.com>)
List pgsql-sql
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/




pgsql-sql by date:

Previous
From: Andy Lewis
Date:
Subject: Re: [SQL] Design Question
Next
From: Julien Cadiou
Date:
Subject: recusrion