Re: Inheritance

From: Ian Turner <vectro(at)pipeline(dot)com>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Inheritance
Date: 2000-07-30 06:44:41
Message-ID: Pine.LNX.4.21.0007292343440.830-100000@crafter.house
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> `SELECT * FROM Entities*;'
>
> up to and including 7.0.x.
>
> In 7.1, I believe a select on the parent will automatically show the
> children and you will need to do something like `SELECT * FROM ONLY Entities'
> to exclude descendant tables.

Yes, but what about referential integrity? Can I have a table column
reference a column from Entities*? In my experimentation, this is not the
case.

Ian
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE5g87bfn9ub9ZE1xoRAmKzAJwLgpj/eutM7WyWBfiaukLOeA3SmQCeIYbY
pa8M8FA18fnimk5DDF4UlEg=
=W2iE
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2000-07-30 11:48:04 Re: Inheritance
Previous Message Oliver Elphick 2000-07-30 05:23:09 Re: Inheritance