how to sort a birthday list ? - Mailing list pgsql-sql

From Michael Agbaglo
Subject how to sort a birthday list ?
Date
Msg-id 3D122508.70104@shifted-bytes.de
Whole thread Raw
Responses Re: how to sort a birthday list ?  (David Stanaway <david@stanaway.net>)
Re: how to sort a birthday list ?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-sql
Hi !

there's a nice query for retrieving the people who have their birthday 
in the next n days: (taken from Joe Celko's SQL for Smarties, 1st Ed., 
p. 76)

SELECT *
FROM Persons
WHERE EXTRACT( YEAR FROM AGE(dateofbirth) ) < EXTRACT( YEAR FROM AGE( 
CURRENT_DATE+60, dateofbirth ) )

... but how do I sort the list ?



pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Tagging rows into collections?
Next
From: David Stanaway
Date:
Subject: Re: how to sort a birthday list ?