pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (5+ messages)

Message-ID: <375D6E28.612B2C06@idianet.net>
Permalink:  ../375D6E28.612B2C06@idianet.net/
Also on:    postgresql.org/message-id/375D6E28.612B2C06@idianet.net

 · 

reply

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