Hi.
I have a table roughly like this
create table friends(
friendid serial,
friendname varchar,
dateofbirth timestamp,
primary id(friendid));
and the data looks like
1 Tony 1978/01/28
2 Gary 1966/06/04
3 Jodie 1979/01/11
and so on..
How do i select from the table, so that I get the tuples ordered with
the one having birthsday first from now first (and then ascending
order) ???
Tia
Svenne
--
Mail usenet@krap.dk - svenne@krap.dk - PGP key id : 0xDF484022
ICQ: 5434480 - http://www.krap.dk - http://www.krap.net
PGP Key http://keys.pgp.dk:11371/pks/lookup?op=get&search=0xDF484022