Search Postgresql Archives

Re: Unexplained case insensitive results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Lloyd Mason" <LloydM@xxxxxxxxxxx>
Subject: Re: Unexplained case insensitive results
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 02 Apr 2007 12:17:43 -0400
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to "Lloyd Mason" <LloydM@xxxxxxxxxxx> message dated "Fri, 30 Mar 2007 16:44:13 -0400"
In-reply-to: <C34A4F8A078F5E4285EB8B10FF0DAF31182780@xxxxxxxxxxxxxxxxxxxxxxxx>
References: <C34A4F8A078F5E4285EB8B10FF0DAF31182780@xxxxxxxxxxxxxxxxxxxxxxxx>

"Lloyd Mason" <LloydM@xxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Unexplained case insensitive results
  - From: Lloyd Mason

References:
- Unexplained case insensitive results
  - From: Lloyd Mason

Prev by Date: Re: [ADMIN] Increasing the shared memory
Next by Date: Webappication and PostgreSQL login roles
Previous by thread: Re: Unexplained case insensitive results
Next by thread: Re: Unexplained case insensitive results
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux