Re: [GENERAL] FW: inheritance of functions

Поиск
Список
Период
Сортировка
От Aaron J. Seigo
Тема Re: [GENERAL] FW: inheritance of functions
Дата
Msg-id 99102709413700.03504@stilborne
обсуждение исходный текст
Ответ на FW: inheritance of functions  (Andrzej Mazurkiewicz <andrzej.mazurkiewicz@polkomtel.com.pl>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Alain TESIO
Дата:
Сообщение: Re: [GENERAL] how to insert from sequence
Следующее
От: bayard kohlhepp
Дата:
Сообщение: [GENERAL] how do you specify null date field thru ecpg?