Thank you Laurenz for your answer.
I think I understand the meaning of ORDER BY my problem is the
understanding of COLLATE functionality. I thought that if I collate in es.PE
(Spanish) the "o" has the exact value of "ó" so if I
INSERT INTO pru VALUES (8, 'leo','zara', 'juan');
How can I obtain
On 05/04/2012 07:31 PM, Tom Lane wrote:
Al Eridani writes:
What Tulio is saying is that 'leon' and 'león' are the same thing from
the point of view of sorting in Spanish, but his PostgreSQL seems to
think that 'leon' goes before 'león'.
Postgres never considers that two distinct strings are "e
Al Eridani writes:
> What Tulio is saying is that 'leon' and 'león' are the same thing from
> the point of view of sorting in Spanish, but his PostgreSQL seems to
> think that 'leon' goes before 'león'.
Postgres never considers that two distinct strings are "equal". If the
locale setting conside
On Fri, May 4, 2012 at 1:22 AM, Albe Laurenz wrote:
> But would you really order 'leon', 'mendoza', 'juan' before
> 'leo', 'zara', 'juan'?
No, I guess that Tulio would not do that, because (usually) 'leo' goes
before 'leon'.
What Tulio is saying is that 'leon' and 'león' are the same thing from
Tulio wrote:
> Let me expand the collate situation. I´m from Perú and I have turned
> everything in postgresql.conf as 'es_PE.UTF-8' even the
> default_text_search_config = 'pg_catalog.spanish'. Even my Ubuntu 12.04
> works in English I have es_PE locale too.
> if I do
>
> SELECT * FROM pru order
Hi there,
Let me expand the collate situation. I´m from Perú and I have turned
everything in postgresql.conf as 'es_PE.UTF-8' even the
default_text_search_config = 'pg_catalog.spanish'. Even my Ubuntu 12.04
works in English I have es_PE locale too.
In Spanish vowels as "u" is equal as "ú" or even
Laurenz, thank you so much for your help. I had a hard time getting the
es_MX locale installed on my freebsd system, but once I did it worked
perfectly. Thanks for your help again.
- Jose
On Thu, Apr 19, 2012 at 2:30 AM, Albe Laurenz wrote:
> jbiskofski wrote:
> > I have a lc_collate problem. Im
jbiskofski wrote:
> I have a lc_collate problem. Im in Mexico and I need the following three
> lastnames to be sorted this
> way :
>
> álvarez ( accent on first a )
> chavez
> cota
>
> Using the default locale on my mac ( en_US ) I end up with :
>
> chavez
> cota
> álvarez
>
> So I switched to
Hello everyone,
I have a lc_collate problem. Im in Mexico and I need the following three
lastnames to be sorted this way :
álvarez ( accent on first a )
chavez
cota
Using the default locale on my mac ( en_US ) I end up with :
chavez
cota
álvarez
So I switched to es_ES.ISO8859-15 and that gives
