pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Welcome to the pgsql-admin list!
2+ messages / 2 participants
[nested] [flat]
* Re: Welcome to the pgsql-admin list!
@ 2008-07-23 09:23 Gibson Chimhamhiwa <gchimhamhiwa@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Gibson Chimhamhiwa @ 2008-07-23 09:23 UTC (permalink / raw)
To: pgsql-admin
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>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Welcome to the pgsql-admin list!
@ 2008-07-23 14:39 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Gibson Chimhamhiwa <gchimhamhiwa@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Kevin Grittner @ 2008-07-23 14:39 UTC (permalink / raw)
To: Gibson Chimhamhiwa <gchimhamhiwa@gmail.com>; pgsql-admin
>>> "Gibson Chimhamhiwa" <gchimhamhiwa@gmail.com> wrote:
> 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
SELECT * FROM grouping;
If that isn't what you're looking for, we need more information to be
able to help.
If you follow up on this, please start a new thread with a subject
line appropriate to the discussion; it will help the right people
notice your mail.
-Kevin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-07-23 14:39 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-07-23 09:23 Re: Welcome to the pgsql-admin list! Gibson Chimhamhiwa <gchimhamhiwa@gmail.com>
2008-07-23 14:39 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
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