Skip site navigation (1) Skip section navigation (2)

Re: select fails on indexed varchars.

From: Alex Krohn <alex(at)gossamer-threads(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: select fails on indexed varchars.
Date: 2001-01-27 00:45:24
Message-ID: 20010126164424.0BFD.ALEX@gossamer-threads.com (view raw or flat)
Thread:
Lists: 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(at)gossamer-threads(dot)com
Internet Consultant               Phone: (604) 687-5804
http://www.gossamer-threads.com   Fax  : (604) 687-5806


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-01-27 00:47:54
Subject: Re: select fails on indexed varchars.
Previous:From: Tom LaneDate: 2001-01-27 00:35:18
Subject: Re: select fails on indexed varchars.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group