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, <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]:
>
> approve QiFiDx unsubscribe pgsql-admin [EMAIL PROTECTED]
>
> 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
> [email protected]
>
> If you need help or have questions about the mailing list, please
> contact the people who manage the list by sending a message to
> [EMAIL PROTECTED]
>
> 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:[EMAIL PROTECTED] <[EMAIL PROTECTED]>
