Postgres Pro
Downloads
Home   >   mailing lists

Re: Unexplained case insensitive results - Mailing list pgsql-general

From Tom Lane
Subject Re: Unexplained case insensitive results
Date
Msg-id 10622.1175530663@sss.pgh.pa.us
Whole thread Raw
In response to Unexplained case insensitive results  ("Lloyd Mason" <LloydM@pbsinet.com>)
Responses Re: Unexplained case insensitive results  ("Lloyd Mason" <lloydm@pbsinet.com>)
List pgsql-general
Tree view 
"Lloyd Mason" <LloydM@pbsinet.com> writes:
> There appears to be a difference in the results from the following SQL
> statement when run on an 8.1.5 version versus a 8.1.8 version:

I imagine you initdb'd the two installations with different locale
settings.  Check "show lc_collate".

            regards, tom lane

pgsql-general by date:

Previous
From: David Brain
Date:
Subject: Re: [ADMIN] Increasing the shared memory
Next
From: Thorsten Kraus
Date:
Subject: Webappication and PostgreSQL login roles