order by

Is there a known problem with the SQL order by clause within postgres version 7.2.3?

I am trying to sort a field which holds file names that have some spaces as well non-alphanumeric characters, including underscores (see below).

The results of:
select study_name from study order by study_name;


  Study1a
  Study 1b
  Study  1c
  Study1d


The results of sorting in Perl (which uses Linux's underlying sort function)

Study  1c
Study 1b
Study1a
Study1d

Is there any way around this difference? Blank spaces should show up first in the sort.

Thanks

Jodi

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@xxxxxxxxxxxx