Alex Krohn <[EMAIL PROTECTED]> writes: > links=# select * from foo where a like 'Test/%' > links-# ; > a > --- > (0 rows) This looks like an artifact of the known problems with LIKE index optimization in non-ASCII locales. What locale are you running the postmaster in? regards, tom lane
- [BUGS] select fails on indexed varchars. Alex Krohn
- Re: [BUGS] select fails on indexed varchars. Tom Lane
- Re: [BUGS] select fails on indexed varchars. Tom Lane
- Re: [BUGS] select fails on indexed varchars. Tom Lane
- Re: [BUGS] select fails on indexed varchars. Tom Lane
- Re: [BUGS] select fails on indexed varchars. Tom Lane
- Re: [BUGS] select fails on indexed varchars. Alex Krohn
- Re: [BUGS] select fails on indexed varchars. Alex Krohn
- Re: [BUGS] select fails on indexed varchars. Alex Krohn
- Re: [BUGS] select fails on indexed varchars. Alex Krohn
- Re: [BUGS] select fails on indexed varchars. Alex Krohn
- Re: [BUGS] select fails on indexed varchars. Tom Lane