Octavio Alvarez writes:
> No accents here. I would have expected:
> p | m
> -------+-------
> OCTAV | ALVAA
> octav | alvar
> OCTAV | ALVAZ
> OCTIa | ALVAa
> octia | alvra
> OCTIb | ALVZa
> OCTIb | ALVZa
> OCTIc | ALVAa
> octic | alvra
> OCTVI | ALVAa
> octvi | alvra
> OCTVI | ALVZa
> (12 rows)
That's not the way it works. First it sorts by p, then by m -- there is
no cross-column magic. Maybe for your application you will be happier if
you sort by lower(p), lower(m).
--
Peter Eisentraut peter_e@gmx.net