ORDER BY question

From: Charles Hauser <chauser(at)acpub(dot)duke(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: ORDER BY question
Date: 2001-11-15 23:02:04
Message-ID: a05010403b819f5e7857d@[152.3.11.193]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-11-15 23:07:28 Cross-posting (was Re: PL/pgSQL examples NOT involving functions)
Previous Message Ross J. Reedstrom 2001-11-15 22:09:02 Re: INSERT question