Re: [GENERAL] Nested tables - Mailing list pgsql-general

From omid omoomi
Subject Re: [GENERAL] Nested tables
Date
Msg-id 20000304070453.19526.qmail@hotmail.com
Whole thread Raw
List pgsql-general
>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


pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [GENERAL] Nested tables
Next
From: Alex Pilosov
Date:
Subject: binary data & LOBs