Received: from ns.idianet.net ([195.154.201.1]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA01366 for ; Tue, 8 Jun 1999 13:25:18 -0400 (EDT) (envelope-from haj@idianet.net) Received: from idianet.net (ppp156-paris.isdnet.net [194.149.182.156]) by ns.idianet.net (8.9.1/8.9.1) with ESMTP id TAA19597 for ; Tue, 8 Jun 1999 19:24:34 +0200 (CEST) Sender: haj@ns.idianet.net Message-ID: <375D6E28.612B2C06@idianet.net> Date: Tue, 08 Jun 1999 19:25:28 +0000 From: Jonathan Davis Reply-To: haj@idianet.net X-Mailer: Mozilla 4.08 [en] (X11; I; FreeBSD 3.1-RELEASE i386) MIME-Version: 1.0 To: pgsql-general@postgreSQL.org Subject: Re: [GENERAL] Trying to make functions in 'C' References: <19990516162326.84206.qmail@hotmail.com> <87n1z46vmn.fsf@tolikus.hq.aaanet.ru> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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