Thom Brown <thom@xxxxxxxxx> writes: > On 6 April 2011 05:44, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> It looks like the index predicate expression isn't getting the right >> collation assigned, so predtest.c decides the query doesn't imply the >> index's predicate. Too tired to look into exactly why right now, but >> it's clearly bound up in all the recent collation changes. > Testing it again with very explicit collations, it still has issues: Yeah, any sort of collation-sensitive operator in an index WHERE clause was just plain broken. Fixed now. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
