Svenne Krap <svenne.li...@krap.dk> wrote: > I have the information attached here instead...
I find it suspicious that the test is using an index which sorts first by the "f1" column, then later by "f1 text_pattern_ops" column. I'm not 100% sure whether the test is bad or you have found a bug, although I suspect the latter. The actual result should not depend on the index definition; the index should only affect performance and possibly the order of results where order is not specified. -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers