Topic: The filter on an index
There is an indexed field varchar (150)
select * from the table where a field = ' a line'
index scan, 0 lines
select *, a field =' ' from the table where a field || "= ' a line'
Seq scan, 5 lines, at all (a field =' ') = true
How such can be?
PostgreSQL 9.5.0, compiled by A Visual C ++ build 1800, 64-bit
PS reindex did not help.