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: | Raw Message | Whole Thread | 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 |