ORDER BY question

From: "Grant Henderson" <granth(at)fusion-advertising(dot)co(dot)uk>
To: <pgsql-php(at)postgresql(dot)org>
Subject: ORDER BY question
Date: 2003-02-27 10:09:58
Message-ID: 31EA81C61A3D014F8D6933864F32C604059151@server1.fusion-advertising.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

I have a field with names in which I wish to sort using ORDER BY.

The data comes back as [A-Z][a-z]
Apple
Blackberry
Kiwi
aardvark
banana

It should be [Aa-Zz]
aardvark
Apple
banana
Blackberry
Kiwi

They seem to be sorting using the ASCII equivelant.

Is there any way to do a case insensitive sort?.

Thanks in advance
Grant

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Adrian Tineo 2003-02-27 10:54:06 Re: ORDER BY question
Previous Message Christopher Kings-Lynne 2003-02-26 01:23:09 Re: list archive