Jonathan Davis wrote:
> hello
>
> CREATE SEQUENCE seq
>
> INCREMENT 1
> MINVALUE 1
> START 1
> ;
>
> CREATE TABLE T (
> index int primary key UNIQUE DEFAULT nextval('seq'),
> f1 char(5),
> f2 char(5)
>
> );
>
> CREATE TABLE T1 (
> f3 char(5),
> f4 char(5),
> f5 char(5)
>
> ) INHERITS (T);
>
> CREATE TABLE T2(
> cp1 char(5),
> cp2 char(5)
> ) INHERITS (T);
>
> INSERT INTO T1 VALUES ( nextval('seq'), 'joe', 'joe', 'joe', 'joe', 'joe');
> INSERT INTO T1 VALUES ( nextval('seq'), 'davis', 'davis', 'davis', 'davis',
> 'davis');
> INSERT INTO T1 VALUES ( nextval('seq'), 'ba', 'ba', 'ba', 'ba', 'ba');
>
> INSERT INTO T2 VALUES ( nextval('seq'), 'aw', 'aw', 'aw', 'aw');
> INSERT INTO T2 VALUES ( nextval('seq'), 'es', 'es', 'es', 'es');
>
> SELECT * FROM T*;
>
> this request give me only the fields in table T but I want to give me all
> fiels in T1 and T2
> how ?
>
> thanks
