Re: [GENERAL] Trying to make functions in 'C'

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