Re: select fails on indexed varchars.

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@gossamer-threads.com
Internet Consultant               Phone: (604) 687-5804
http://www.gossamer-threads.com   Fax  : (604) 687-5806