Thread: INHERITANCE

I have just been trying out

Create Table .. Inherits ( ..);

Am I right in saying you create a table that inherits fields & default values, but not triggers.

I have not tried rules or anything else yet.  Where can I read more about inheritance and where to use it.

Thanks in advance,

Ben Trewern

> "Trewern, Ben" wrote:
>
> I have just been trying out
>
> Create Table .. Inherits ( ..);
>
> Am I right in saying you create a table that inherits fields & default
> values, but not triggers.
>
> I have not tried rules or anything else yet.  Where can I read more
> about inheritance and where to use it.

I think only fields and default values are inherited. Ideally everything
would be inherited unless you specify otherwise, like indexes, rules etc
etc, but currently that is not implemented. The manual is the place to
start with regards these features.