From: Gibson Chimhamhiwa <gchimhamhiwa@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Welcome to the pgsql-admin list!
Date: Wed, 23 Jul 2008 11:23:41 +0200
Message-ID: <f2b0d8200807230223p2f9fb10i5d513c187f1df7a0@mail.gmail.com> (raw)
In-Reply-To: <20080723091232.AEE7A37B4AB@mx3.hub.org>
References: <20080723091232.AEE7A37B4AB@mx3.hub.org>
Hi All,
I have a simple table below and I want to be able to traverse it using SQL.
Can somebody please advise me how I can do this in postgreSQL.
CREATE TABLE grouping
(
grouping_id int4 NOT NULL,
version int4,
parent_grouping_id int4,
topic_topic_id int4,
CONSTRAINT grouping_pkey PRIMARY KEY (grouping_id),
CONSTRAINT fk1e2e9d036852722d FOREIGN KEY (topic_topic_id)
REFERENCES topic (topic_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk1e2e9d03a1bfbfe FOREIGN KEY (topic_topic_id)
REFERENCES topic (topic_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT fk1e2e9d03cdaf7222 FOREIGN KEY (parent_grouping_id)
REFERENCES grouping (grouping_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITHOUT OIDS;
ALTER TABLE grouping OWNER TO napdba;
Thanks In Advance.
Gibson.
On Wed, Jul 23, 2008 at 11:12 AM, <pgsql-admin-owner@postgresql.org> wrote:
> Welcome to the pgsql-admin mailing list!
> Your password at postgresql.org is
>
> QiFiDx
>
> To leave this mailing list, send the following command in the body
> of a message to majordomo@postgresql.org:
>
> approve QiFiDx unsubscribe pgsql-admin gchimhamhiwa@gmail.com
>
> This command will work even if your address changes. For that reason,
> among others, it is important that you keep a copy of this message.
>
> To post a message to the mailing list, send it to
> pgsql-admin@postgresql.org
>
> If you need help or have questions about the mailing list, please
> contact the people who manage the list by sending a message to
> pgsql-admin-owner@postgresql.org
>
> You can manage your subscription by visiting the following WWW location:
> <
> http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org/gchimhamhiwa%40gmail.com
> >
>
>
> Put the text of the welcome message here.
>
>
--
Gibson Chimhamhiwa
CSIR - Meraka Institute
P O Box 395, Pretoria 0001
South Africa
www.csir.co.za / www.meraka.org.za
Office: +27 12 841 2758
Mobile: +27 78 447 2879
Fax: +27 12 841 4720
E-mail:gchimhamhiwa@gmail.co.za <E-mail%3Agchimhamhiwa@gmail.co.za>
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gchimhamhiwa@gmail.com
Subject: Re: Welcome to the pgsql-admin list!
In-Reply-To: <f2b0d8200807230223p2f9fb10i5d513c187f1df7a0@mail.gmail.com>
* 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