Inherancing

From: Nasair Junior da Silva <njunior(at)univates(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: Inherancing
Date: 2003-01-07 11:42:25
Message-ID: 20030107094225.0345a050.njunior@univates.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi people,
supposing i have the tables :

create table cities (id int, name varchar, primary key(id) );
create table centers (state varchar(2)) inherits (cities);

ant the tuple
insert into cities values (1, 'Lajeado');

How i do if i want to make this city as a center ?

Thanks,

xx===============================xx
|| °v° Nasair Junior da Silva ||
|| /(_)\ Linux User: 246054 ||
|| ^ ^ njunior(at)univates(dot)br ||
||CPD - Desenvolvimento ||
||Univates - Centro Universitário||
xx===============================xx

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-01-07 12:00:12 Re: [SQL] 7.3.1 index use / performance
Previous Message Adam Witney 2003-01-07 11:03:15 Re: SQL list table names