Re: Inherancing

On 7/1/03 11:42 am, "Nasair Junior da Silva" <njunior(at)univates(dot)br> 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.