ORDER BY case insensitive?

How do I get the rows sorted in a case insensitive way?

I have some queries that basically fit the form:    SELECT * FROM MyTable ORDER BY Name;
When I view the results, all of the Name's that start with an upper case
letter precede all of the Name's that start with a lower case letter.  I
want them all in alphabetic order, regardless of case.

I've looked in PostgreSQL Introduction and Concepts by Bruce Momjian and in
the FAQ at http://postgresql.overtone.org/docs/faq-english.html

Thanks for your help.

--
Bob Swerdlow
Chief Operating Officer
Transpose, LLC
rswerdlow@transpose.com