Konstantin Knizhnik <k.knizh...@postgrespro.ru> writes: > My proposal is to check value of function for functional indexes instead > of just comparing set of effected attributes. > Obviously, for some complex functions it may have negative effect on > update speed. > This is why I have added "surjective" option to index.
This seems overcomplicated. We would have to compute the function value at some point anyway. Can't we refactor to do that earlier? regards, tom lane -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers