From: Jonathan Davis <haj@idianet.net>
To: pgsql-general@postgreSQL.org
Subject: Re: [GENERAL] Trying to make functions in 'C'
Date: Tue, 08 Jun 1999 19:25:28 +0000
Message-ID: <375D6E28.612B2C06@idianet.net> (raw)
References: <19990516162326.84206.qmail@hotmail.com>
<87n1z46vmn.fsf@tolikus.hq.aaanet.ru>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: haj@idianet.net
Subject: Re: [GENERAL] Trying to make functions in 'C'
In-Reply-To: <375D6E28.612B2C06@idianet.net>
References: <19990516162326.84206.qmail@hotmail.com> <87n1z46vmn.fsf@tolikus.hq.aaanet.ru> <375D6E28.612B2C06@idianet.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox