| From: | basti <mailinglist(at)unix-solution(dot)de> |
|---|---|
| To: | "Basques, Bob (CI-StPaul)" <bob(dot)basques(at)ci(dot)stpaul(dot)mn(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgresql order lowercase before uppercase |
| Date: | 2021-03-18 15:17:42 |
| Message-ID: | 645e31e2-29aa-68ac-2499-0c93bb380970@unix-solution.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
This does not help in that case.
On 18.03.21 15:45, Basques, Bob (CI-StPaul) wrote:
> Maybe check out using the UPPER/LOWER/INITCAP functions in the order by clause?
>
> Bobb
>
>
>
>> -----Original Message-----
>> From: basti <mailinglist(at)unix-solution(dot)de>
>> Sent: Thursday, March 18, 2021 9:40 AM
>> To: pgsql-general(at)postgresql(dot)org
>> Subject: postgresql order lowercase before uppercase
>>
>> Think Before You Click: This email originated outside our organization.
>>
>>
>> Hello,
>> I need to as follow:
>>
>> ande
>> Amma
>> Anit
>> Anti
>> Brac
>> Cali
>> ....
>>
>> I have try ORDER by name COLLATE 'C';
>>
>> but this order as follow:
>>
>> Amma
>> Anit
>> Anti
>> Brac
>> Cali
>> ....
>> ande
>>
>> Best Regards
>>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc Millas | 2021-03-18 15:36:51 | Re: postgresql order lowercase before uppercase |
| Previous Message | Basques, Bob (CI-StPaul) | 2021-03-18 14:45:33 | RE: postgresql order lowercase before uppercase |