Best way to represent values.

From: Dennis Veatch <dveatch(at)woh(dot)rr(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Best way to represent values.
Date: 2005-11-21 18:19:34
Message-ID: 200511211319.34423.dveatch@woh.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have several fields that needs to be within a table but not real sure the
best way to represent this data.

The scenario I'm trying to incorporate is a form that has to be filled out
went a well is drilled and then sent to the state. One of the things the form
wants is the different depths various types of underburden was encountered.

So you start with topsoil that goes from 0 feet to X depth, then say at that X
depth clay is encountered to depth Y and then at depth Y gravel is
encountered and water is found.

I had thought just adding some fields called topsoil_start/topsoil_end,
gravel_start/gravel_end, etc. But them I'm left with how to take those values
and give to total depth for each layer and total depth of the well.

But I'm not sure that is the best way to handle this.

Does anyone have some other suggestions?

BTW, thanks to all that submitted some recommended PostgreSQL books. I have
started with Beginning Databases with PostgreSQL. It's been very helpful. I
plan to pursue the other recommendations.

--
You can tuna piano but you can't tune a fish.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2005-11-21 19:18:05 Re: Multi-parameter aggregates.
Previous Message Michael Fuhr 2005-11-21 18:15:31 Re: Anomalies with the now() function