Thread: Re: [GENERAL] Nested tables

Re: [GENERAL] Nested tables

From
"omid omoomi"
Date:
>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