pb with select

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