Re: select fails on indexed varchars.

Alex Krohn <alex@gossamer-threads.com> writes:
> 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.

            regards, tom lane