Re: [BUGS] select fails on indexed varchars.

[Tom Lane]

Alex Krohn <[EMAIL PROTECTED]> 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