Postgres Pro
Downloads
Home   >   mailing lists

ORDER BY question - Mailing list pgsql-php

From Grant Henderson
Subject ORDER BY question
Date
Msg-id 31EA81C61A3D014F8D6933864F32C604059151@server1.fusion-advertising.co.uk
Whole thread Raw
List pgsql-php
Tree view 
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

pgsql-php by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: list archive
Next
From: "Adrian Tineo"
Date:
Subject: Re: ORDER BY question