Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> What kind of expression is allowed as the predicate now ?
Anything that doesn't involve an aggregate or a subselect.
(But what the planner can recognize as matching a query's
WHERE clause is currently much more restricted, just ANDs
and ORs of simple VAR OP CONST clauses. This could be
improved in the future.)
> Both the functions used in functional indexes and the
> predicates used in partial indexes must be deterministic.
> Are users responsible for it ?
Yes. I don't see how the system could enforce that, without
prohibiting lots of useful cases.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
