Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 2EF88475ECB
	for <pgsql-sql@postgresql.org>; Fri, 21 Jun 2002 05:23:20 -0400 (EDT)
Received: from mailout09.sul.t-online.com (mailout09.sul.t-online.com
	[194.25.134.84])
	by postgresql.org (Postfix) with ESMTP id 9E49F475E3C
	for <pgsql-sql@postgresql.org>; Fri, 21 Jun 2002 05:23:19 -0400 (EDT)
Received: from fwd00.sul.t-online.de by mailout09.sul.t-online.com with smtp
	id 17LKdU-0003Q8-0D; Fri, 21 Jun 2002 11:23:20 +0200
Received: from avocado.shifted-bytes.de (520056191158-0001@[217.5.59.69]) by
	fmrl00.sul.t-online.com
	with esmtp id 17LKdH-0ZNG5IC; Fri, 21 Jun 2002 11:23:07 +0200
Received: from shifted-bytes.de (orange.shifted-bytes.de [10.0.0.14])
	by avocado.shifted-bytes.de (8.12.2/8.12.2) with ESMTP id
	g5L9N6mI020651
	for <pgsql-sql@postgresql.org>; Fri, 21 Jun 2002 11:23:06 +0200 (CEST)
Message-ID: <3D12F078.2040203@shifted-bytes.de>
Date: Fri, 21 Jun 2002 11:23:04 +0200
From: Michael Agbaglo <byteshifter@shifted-bytes.de>
User-Agent: Mozilla/5.0 (Windows; U; Win98; en-US;
	rv:0.9.4.1) Gecko/20020508 Netscape6/6.2.3
X-Accept-Language: en-us
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: how to sort a birthday list ?
References: <3D122508.70104@shifted-bytes.de>
	<1024608770.9198.75.camel@ciderbox>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Sender: 520056191158-0001@t-dialin.net
X-Archive-Number: 200206/288
X-Sequence-Number: 8253



David Stanaway wrote:

> 
> How about:
> ORDER BY dateofbirth
> 
> 
> 

doesn't work: it's sorted by YEAR ...