Re: [GENERAL] Doubt on query

2008-09-25 Thread ries van Twisk
On Sep 25, 2008, at 4:59 PM, x asasaxax wrote: Hi everyone, I have this table: create table cat( cod integer, cod_super integer, constraint cod_super_fk Foreign Key(cod_super) references cat(cod), constraint cod_pk Primary Key(cod) ); insert into cat values(0, 1); insert into cat val

[GENERAL] Doubt on query

2008-09-25 Thread x asasaxax
Hi everyone, I have this table: create table cat( cod integer, cod_super integer, constraint cod_super_fk Foreign Key(cod_super) references cat(cod), constraint cod_pk Primary Key(cod) ); insert into cat values(0, 1); insert into cat values(1, 0); insert into cat values(2, 0); insert into