Re: ORDERING alphabetically

SELECT * FROM table ORDER BY table;

that seems to do the trick for me when I need to order things alphabeticly.

Mike
----- Original Message -----
From: "abe" <abe(at)fish(dot)tm>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, August 09, 2000 10:15 AM
Subject: [GENERAL] ORDERING alphabetically

> Hi there,
>
> Does anyone know how to get results from a query in alphabetical order
(for one
> field such as surname). I skimmed over the documentation and no luck.
>
> The field type for surname is varchar - Maybe this is why order by didn't
work.
>
> Thankyou,
> Abe
>