istvan.endr...@gmail.com writes:
> there is a table with 3000 rows, and a custom index with a function.
> This query gives negative cost:
> select distinct name
> from negativeCostBugReport t_
> where noaccent(t_.name) like 'B%' limit 10
Hm, interesting. The culprit seems to be the part of c
Hi,
more precisely the given index looks like this:
(to be able to repro the bug)
CREATE INDEX negativecostbugreport_noaccent_idx
ON negativeCostBugReport
USING btree
(noaccent(name) varchar_pattern_ops);
i'm sorry,
Istvan
