Tom Lane wrote:
>
> Mike Mascari <mascarm@mascari.com> writes:
> >> Or will Martijn van Oosterhout's new Partial Indices work allow me to
> >> create a unique index like:
> >> CREATE UNIQUE INDEX i_foo ON foo(value)
> >> WHERE deactive IS NULL;
>
> Just for the record: with CVS tip,
>
What kind of expression is allowed as the predicate now ?
(Sorry I could have had no cvs access for more than a week).
Both the functions used in functional indexes and the
predicates used in partial indexes must be deterministic.
Are users responsible for it ?
regards,
Hiroshi Inoue