Re: [GENERAL] Nested tables

>Table ACL:
> Attribute | Type | Modifier
>---------------+-------------+----------------------------
> uniqid | varchar(12) | not null
> date_created | timestamp | not null
> date_modified | timestamp | not null
> read | boolean | not null default 'f'::bool
> write | boolean | not null default 'f'::bool
> execute | boolean | not null default 'f'::bool
> delete | boolean | not null default 'f'::bool
>
>
>Table myItem:
> Attribute | Type | Modifier
>----------------+-------------+----------
> uniqid | varchar(12) | not null
> date_created | timestamp | not null
> date_modified | timestamp | not null
> author | text | not null
> title | text | not null
> access_control | acl | not null
>
>
>PostgreSQL lets me create the class myItem with a "acl" field type, but I
>can't figure out how to insert multiple values (or any values!) into the
>access_control field...

So you will have your tables with data redundancies and not normalized.

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com