From: | Alex Krohn <alex(at)gossamer-threads(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: select fails on indexed varchars. |
Date: | 2001-01-27 00:45:24 |
Message-ID: | 20010126164424.0BFD.ALEX@gossamer-threads.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi Tom,
> > I added to the startup file:
> > LANG=C
> > LC_CTYPE=C
> > LC_NUMERIC=C
> > LC_TIME=C
> > LC_COLLATE=C
> > LC_MONETARY=C
> > LC_MESSAGES=C
> > LC_ALL=C
>
> Seems reasonable. It's possible you needed "export" commands in there
> too, but I wouldn't have thought so (anything coming in from the outer
> environment should be exported already).
>
> > After this, my create test and select still produced the same error. Ugh.
>
> Hm, maybe I'm barking up the wrong tree. Let's try a direct test.
> What do you get from
>
> select 'a_b'::text < 'ac'::text;
>
> select 'A_B'::text < 'ac'::text;
>
> On my machine, these produce 't' in C locale, but 'f' in en_US locale.
Seem to be in C locale:
links=# select 'a_b'::text < 'ac'::text;
?column?
----------
t
(1 row)
links=# select 'A_B'::text < 'ac'::text;
?column?
----------
t
(1 row)
links=#
Cheers,
Alex
-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: alex(at)gossamer-threads(dot)com
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-27 00:47:54 | Re: select fails on indexed varchars. |
Previous Message | Tom Lane | 2001-01-27 00:35:18 | Re: select fails on indexed varchars. |