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

Comment 1959 added to page ddl-inherit.html of version 7.4

From: nobody <nobody(at)developer(dot)pgadmin(dot)org>
To: pgsql-www(at)postgresql(dot)org
Subject: Comment 1959 added to page ddl-inherit.html of version 7.4
Date: 2004-12-29 15:05:19
Message-ID: 200412291505.iBTF5J58001433@developer.pgadmin.org (view raw or flat)
Thread:
Lists: pgsql-www
Author: sardaukar_siet <sardaukar(dot)siet(at)gmail(dot)com>
----
This example for inheritance is not very good, in my humble opinion - it would be easier to add a boolean toggle in the cities table to indicate if it is or not a capital. A much better example, in my opinion, is this :


 CREATE TABLE baseinfo (
    name            text,
    address         text,
    zipcode         text
);

CREATE TABLE regularclient (
    client_id       char(25)
) INHERITS (baseinfo);

CREATE TABLE supplierclient (
    supplier_id     char(25)
) INHERITS (baseinfo);
----
Manual page: http://wwwmaster.postgresql.org/docs/7.4/static/ddl-inherit.html
Reject:      http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1959
Edit:        http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1959
Delete:      http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1959


pgsql-www by date

Next:From: Devrim GUNDUZDate: 2004-12-29 15:59:40
Subject: Todo list before a release
Previous:From: nobodyDate: 2004-12-29 04:14:23
Subject: Comment #1958 was rejectd by justin

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