Received: from wilson.acpub.duke.edu (wilson.acpub.duke.edu [152.3.233.69])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fAFN25m59335
	for <pgsql-sql@postgresql.org>; Thu, 15 Nov 2001 18:02:05 -0500 (EST)
	(envelope-from chauser@acpub.duke.edu)
Received: from [152.3.11.193] (bglab2.botany.duke.edu [152.3.11.193])
	by wilson.acpub.duke.edu (8.11.5/8.11.3/Duke-5.0.0) with ESMTP id
	fAFN24v16900; Thu, 15 Nov 2001 18:02:05 -0500 (EST)
Mime-Version: 1.0
X-Sender: chauser@mail-ch.acpub.duke.edu
Message-Id: <a05010403b819f5e7857d@[152.3.11.193]>
Date: Thu, 15 Nov 2001 18:02:04 -0500
To: pgsql-sql@postgresql.org
From: Charles Hauser <chauser@acpub.duke.edu>
Subject: ORDER BY question
Content-Type: text/plain; charset="us-ascii" ; format="flowed"
X-Virus-Scanned: by amavisd-milter, Duke University (http://amavis.org/)
X-Archive-Number: 200111/283
X-Sequence-Number: 5665

Hope this is the correct forum - if not sorry.

I have a query which returns a value of the form: '20010822.1338.1'.

I would like to order the results, sorting :

		1st: 20010822
		2nd: 1338
		3rd: 1


I can do this in perl, but have not found a way to do this using ORDER BY.

I am VERY new to DB's; biologist trying to do informatics.

Thanks.
-- 
Chuck