Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E0145650020 for ; Wed, 23 Jul 2008 11:40:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48406-03 for ; Wed, 23 Jul 2008 11:39:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 0E605650010 for ; Wed, 23 Jul 2008 11:40:02 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Wed, 23 Jul 2008 09:40:00 -0500 Message-Id: <4886FCE2.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Wed, 23 Jul 2008 09:39:42 -0500 From: "Kevin Grittner" To: "Gibson Chimhamhiwa" , Subject: Re: Welcome to the pgsql-admin list! References: <20080723091232.AEE7A37B4AB@mx3.hub.org> In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/190 X-Sequence-Number: 29800 >>> "Gibson Chimhamhiwa" 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