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@fish.tm>
To: <pgsql-general@postgresql.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
>