| From: | "JustSomeGuy" <nope(at)nottelling(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | need advice. |
| Date: | 2004-03-04 02:18:30 |
| Message-ID: | Wlw1c.680571$X%5.440770@pd7tw2no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a database that should be quite simple to do.
I have a base object that is easily defined
as
create table myObject (
a integer,
b integer,
len integer,
data bytea
);
Now this really should be a type:
And oddly enough it is the only type of data in the entire database.
A list of these is a row in a table.
The list size is variable.
level a one to many level b
level b one to many level c
level c one to many level d
Each of these levels is a list (or row) of these objects..
What does the scheme or sql of this look like.
I'm sort of new to databases.. but I don't know how to make the 'entity
relationships' between the levels.
Help?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-03-04 03:37:48 | Re: REFERENCES error message complaint, suggestion |
| Previous Message | Matthew Hixson | 2004-03-04 01:03:34 | using Postgres to store many small files |