Re: Sorting Problem

From: "Tim Edwards" <mor4321(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting Problem
Date: 2003-08-13 13:32:10
Message-ID: Law10-F90diz7RzDe1n0001211a@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was afraid of something like that. I found a sort term fix by using the
following:

select remote_model,
translate(remote_model, '-', 'a')
from remote
order by translate(remote_model, '-', 'a') asc

But it's an ugly answer to this, but it works for now. Guess I'm going to be
readin up on Locales

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

Browse pgsql-general by date

  From Date Subject
Next Message Robert Creager 2003-08-13 13:40:07 Re: How to prevent vacuum and reindex from deadlocking.
Previous Message krystoffff 2003-08-13 13:22:52 Re: The database is very slow !