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