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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-27 01:12:01 | Re: select fails on indexed varchars. |
Previous Message | Tom Lane | 2001-01-27 00:47:54 | Re: select fails on indexed varchars. |