Subject: | statistics_info does not return information on functional indices |
Postgres allows for something like:
CREATE INDEX ON TABLE foo USING (foo_field);
CREATE INDEX ON TABLE foo USING (foo_field,bar_field);
CREATE INDEX ON TABLE foo USING (lower(foo_field));
But if you call the function, you don't get the returned handles doesn't
contain the index that uses a function (last example).
$sth = $dbh->statistics_info(undef,'public','foo',undef,undef);
print Dumper($sth->fetchall_arrayref);