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

Re: Case-Insensitve Text Comparison

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Case-Insensitve Text Comparison
Date: 2008-06-02 18:24:12
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Mon, Jun 02, 2008 at 10:29:30AM -0700, Jeff Davis wrote:

> What if you had a CHECK constraint that was locale-sensitive? Would the
> constraint only be non-false (true or null) for records inserted under
> the same locale? That's not very useful.

It would seem that this is one of the important cases that needs to be
worked out.  I wasn't suggesting that per-session locale (or whatever
we want to call it) is _easy_ or, for that matter, even possible; just
that it would solve a large number of the problems that people
complain about.

In fact, I suspect that what we really need is something a little more
like "in-database locale" or something.
> I think if you want some special treatment of text for some users, it
> should be explicit. 

Yes.  Also, not just text.  Think of currency, numeric separators, &c.


Andrew Sullivan
+1 503 667 4564 x104

In response to


pgsql-hackers by date

Next:From: Stefan KaltenbrunnerDate: 2008-06-02 18:33:42
Subject: Re: Where can I find the doxyfile?
Previous:From: Pavel StehuleDate: 2008-06-02 18:10:19
Subject: Re: Proposal: new function array_init

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