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. A -- Andrew Sullivan [EMAIL PROTECTED] +1 503 667 4564 x104 http://www.commandprompt.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers