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 01:03:09
Message-ID: 20010126170104.0C08.ALEX@gossamer-threads.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi Tom,

> Alex Krohn <alex(at)gossamer-threads(dot)com> writes:
> >> On my machine, these produce 't' in C locale, but 'f' in en_US locale.
> 
> > Seem to be in C locale:
> 
> So it does.  Okay, what was the complete test case again?
> I'm afraid I didn't save your original message because I wrote it off
> as a known problem ...

Here it is:

        links=# create table foo ( a char(25) );            
        CREATE
        links=# create index foodx on foo (a);                            
        CREATE
        links=# insert into foo values ('Test/Test');                     
        INSERT 29689 1
        links=# select * from foo;
                     a             
        ---------------------------
         Test/Test                
        (1 row)

        links=# select * from foo where a like 'Test/%';
         a 
        ---
        (0 rows)

Cheers,

Alex

In response to

Responses

pgsql-bugs by date

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

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