Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
Lists: pgsql-general

> >  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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group