in PostgreSQL also support the following features:

* Expression indexes can be created with an index of the result of an expression or function, instead of simply the value of a column.
* Partial indexes, which only index part of a table, can be created by adding a WHERE clause to the end of the CREATE INDEX statement. This allows for a smaller index to be created.
* The planner is able to use multiple indexes together to satisfy complex queries,