| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Postgresql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Server locale? |
| Date: | 2002-10-08 07:25:16 |
| Message-ID: | 20021008072516.GC558@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 08, 2002 at 09:07:49AM +0200, Karel Zak wrote:
> On Mon, Oct 07, 2002 at 10:17:35AM -0400, Tom Lane wrote:
> > 7.3 has some of the LC_ things exposed as GUC variables, but not
> > COLLATE.
>
> Oh, sorry. By the way, why not COLLATE, why not all?
That's really wierd. Anyway, it means that from a users point of view, ORDER
BY on a string column has undefined results, since the server could be using
any locale and you have no way of determining what it is.
Best stick to sorting in the user code. Sigh.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2002-10-08 07:41:59 | Re: How to find out about index |
| Previous Message | Martijn van Oosterhout | 2002-10-08 07:20:47 | Re: [pgsql-performance] Large databases, performance |