or, maybe, just nothing ? Marc MILLAS Senior Architect +33607850334 www.mokadb.com
On Thu, Mar 18, 2021 at 4:44 PM Ron <ronljohnso...@gmail.com> wrote: > Exactly. "C" collation is the opposite of what he wants. > > OP needs something like "de_DE". > > On 3/18/21 10:36 AM, Marc Millas wrote: > > to me, collate 'C' ask for the raw ascii order which put caps before > because the hexa coding is lower > did you try any thing else (POSIX is same as 'C') > > Marc MILLAS > Senior Architect > +33607850334 > www.mokadb.com > > > > On Thu, Mar 18, 2021 at 4:18 PM basti <mailingl...@unix-solution.de> > wrote: > >> 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 <mailingl...@unix-solution.de> >> >> Sent: Thursday, March 18, 2021 9:40 AM >> >> To: pgsql-gene...@postgresql.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 >> >> >> > >> >> >> > -- > Angular momentum makes the world go 'round. >
