Re: [BUGS] select fails on indexed varchars.

[Alex Krohn]

Hi Tom,

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