Re: [GENERAL] FW: inheritance of functions

From: "Aaron J(dot) Seigo" <aaron(at)gtv(dot)ca>
To: Andrzej Mazurkiewicz <andrzej(dot)mazurkiewicz(at)polkomtel(dot)com(dot)pl>, "'pgsql-general(at)hub(dot)org'" <pgsql-general(at)hub(dot)org>
Subject: Re: [GENERAL] FW: inheritance of functions
Date: 1999-10-27 15:39:10
Message-ID: 99102709413700.03504@stilborne
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi...

> > Postgres automatically allows the created table to inherit functions on
> > tables above it in the inheritance hierarchy.
> > create table A (
> > .
> > .
> > );
> >
> > create function F ...
> >
> > create table B (
> > ..
> > ) inherits (A);
> >
> > Now I assume that I can somehow use function F on table B

you would be able to use function F on table B even if it didn't inherit A.

however, if you construct rules, triggers, etc... on table A, these should be
inherited by table B.

the manual is, as far as my experience has led me to believe, referring to
functions "bound" (for lack of a better word) to the parent table....

--
Aaron J. Seigo
Sys Admin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message bayard kohlhepp 1999-10-27 16:03:21 [GENERAL] how do you specify null date field thru ecpg?
Previous Message Alain TESIO 1999-10-27 15:22:33 Re: [GENERAL] how to insert from sequence