Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 0C830476F37 for ; Tue, 7 Jan 2003 06:45:37 -0500 (EST) Received: from mercurio.fates.tche.br (unknown [200.132.250.35]) by postgresql.org (Postfix) with ESMTP id 46B58476A95 for ; Tue, 7 Jan 2003 06:44:47 -0500 (EST) Received: from fates.tche.br (saturno.fates.tche.br [200.132.250.48]) by mercurio.fates.tche.br (8.12.3/8.12.3) with SMTP id h07Bi9S4019342 for ; Tue, 7 Jan 2003 09:44:09 -0200 Date: Tue, 7 Jan 2003 09:42:25 -0200 From: Nasair Junior da Silva To: pgsql-sql@postgresql.org Subject: Inherancing Message-Id: <20030107094225.0345a050.njunior@univates.br> Reply-To: njunior@univates.br Organization: Univates - Centro =?ISO-8859-1?Q?Universit=E1rio?= X-Mailer: Sylpheed version 0.8.8 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-MailScanner: Found to be clean X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/52 X-Sequence-Number: 10917 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@univates.br || ||CPD - Desenvolvimento || ||Univates - Centro Universitário|| xx===============================xx