Skip site navigation (1) Skip section navigation (2)

Re: Case-Insensitve Text Comparison

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Case-Insensitve Text Comparison
Date: 2008-06-02 17:56:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Sun, 2008-06-01 at 22:13 -0700, David E. Wheeler wrote:
> What locale is right? If I have a Web app, there could be data in many  
> different languages in a single table/column.

I think the values should be explicitly treated differently. 

It would be nice if you could just typecast, like:

which would then lowercase according to the fr_CA locale, regardless of
the locale of "somevalue".

Using typmod for localization was brought up here:

Has it been discussed further? I happen to like the idea of the TEXT
type taking a locale as a typmod. No typmod would, of course, fall back
to the cluster setting. And it would throw an exception if the encoding
couldn't represent that locale.

	Jeff Davis

In response to

pgsql-hackers by date

Next:From: Josh BerkusDate: 2008-06-02 18:06:04
Subject: Re: Overhauling GUCS
Previous:From: Martijn van OosterhoutDate: 2008-06-02 17:55:16
Subject: Re: Case-Insensitve Text Comparison

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group