Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id F0976475F25 for ; Tue, 7 Jan 2003 07:01:57 -0500 (EST) Received: from mailhub2.sghms.ac.uk (firewall.sghms.ac.uk [194.82.50.2]) by postgresql.org (Postfix) with ESMTP id 5BC83475E31 for ; Tue, 7 Jan 2003 07:01:57 -0500 (EST) Received: from [194.82.51.24] (helo=imail) by mailhub2.sghms.ac.uk with esmtp (Exim 4.05) id 18VsNX-0005Nn-00; Tue, 07 Jan 2003 11:58:43 +0000 Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3]) by imail.sghms.ac.uk (iPlanet Messaging Server 5.1 HotFix 0.7 (built May 7 2002)) with ESMTPA id <0H8C00I0TER5RG@imail.sghms.ac.uk>; Tue, 07 Jan 2003 12:01:53 +0000 (GMT) Date: Tue, 07 Jan 2003 12:02:13 +0000 From: Adam Witney In-reply-to: <20030107094225.0345a050.njunior@univates.br> To: njunior@univates.br, pgsql-sql Message-id: MIME-version: 1.0 User-Agent: Microsoft-Entourage/10.1.1.2418 Subject: Re: Inherancing Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT X-Spam-Status: No, hits=-103.2 required=5.7 tests=EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, SPAM_PHRASE_00_01,USER_AGENT,USER_AGENT_ENTOURAGE, USER_IN_WHITELIST version=2.43 X-Spam-Level: X-MailScanner-MH2: Found to be clean X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/53 X-Sequence-Number: 10918 On 7/1/03 11:42 am, "Nasair Junior da Silva" wrote: > 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 ? If I understand you correctly you probably want to do this instead... insert into centers values (1, 'Lajeado', 'AZ'); Where AZ is your state HTH adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.