Re: select fails on indexed varchars. - Mailing list pgsql-bugs

From Alex Krohn
Subject Re: select fails on indexed varchars.
Date
Msg-id 20010126164424.0BFD.ALEX@gossamer-threads.com
Whole thread Raw
In response to Re: select fails on indexed varchars.  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@gossamer-threads.com
Internet Consultant               Phone: (604) 687-5804
http://www.gossamer-threads.com   Fax  : (604) 687-5806

pgsql-bugs by date:

Previous
From: aoki@acm.org (Paul M. Aoki)
Date:
Subject: Re: [JDBC] Re: no way in LargeObject API to detect short read?
Next
From: Tom Lane
Date:
Subject: Re: select fails on indexed varchars.