postgresql order by (text field)

admin

Administrator
Staff member
when selecting and ordering by a text field in postgresql it puts the list in order of A-Z then a-z, putting all capitalized words before the lowercase words (Zoo before apple).

There must be a way to get around this, and it must be simple, and I'm probably dumb, but hey, will someone please help me out here :P

Thanks,
Chief
<!-- m --><a class="postlink" href="http://www.crudpot.net">http://www.crudpot.net</a><!-- m -->
 
Back
Top